Skip to content

Instantly share code, notes, and snippets.

@mvitor

mvitor/gist:720101

Created November 29, 2010 15:47
Show Gist options
  • Save mvitor/720101 to your computer and use it in GitHub Desktop.
Save mvitor/720101 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
1) mysql> show full processlist;
+---------+--------+-----------------+----------+---------+------+-------+-----------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+--------+-----------------+----------+---------+------+-------+-----------------------------------------------------------------------------------------+
| 1408618 | online | localhost | dblojapr | Query | 0 | NULL | show full processlist |
| 1409948 | online | wserv-20i:54915 | dblojapr | Sleep | 5 | | NULL |
| 1409950 | online | wserv-20i:54916 | dblojapr | Sleep | 5 | | NULL |
| 1410001 | online | wserv-17i:54024 | dblojapr | Sleep | 2 | | NULL |
| 1410002 | online | wserv-17i:54025 | dblojapr | Sleep | 0 | | NULL |
| 1410023 | online | wserv-20i:54945 | dblojapr | Sleep | 1 | | NULL |
| 1410024 | online | wserv-20i:54946 | dblojapr | Sleep | 0 | | NULL |
| 1410025 | online | wserv-20i:54947 | dblojapr | Sleep | 0 | | NULL |
| 1410026 | online | wserv-20i:54948 | dblojapr | Sleep | 0 | | NULL |
| 1410030 | online | wserv-18i:54125 | dblojapr | Sleep | 0 | | NULL |
| 1410031 | online | wserv-20i:54951 | dblojapr | Sleep | 0 | | NULL |
| 1410032 | online | wserv-18i:54126 | dblojapr | Sleep | 0 | | NULL |
| 1410033 | online | wserv-20i:54952 | dblojapr | Sleep | 0 | | NULL |
| 1410034 | online | wserv-20i:54953 | dblojapr | Sleep | 0 | | NULL |
| 1410035 | online | wserv-18i:54131 | dblojapr | Sleep | 0 | | NULL |
| 1410036 | online | wserv-20i:54954 | dblojapr | Sleep | 0 | | NULL |
| 1410037 | online | wserv-18i:54133 | dblojapr | Sleep | 0 | | NULL |
| 1410038 | online | wserv-18i:54135 | dblojapr | Sleep | 0 | | NULL |
| 1410039 | online | wserv-18i:54136 | dblojapr | Sleep | 0 | | NULL |
| 1410040 | online | wserv-18i:54137 | dblojapr | Sleep | 0 | | NULL |
| 1410041 | online | wserv-18i:54138 | dblojapr | Query | 0 | NULL | SELECT Catalogo FROM car WHERE (Ped_loja = 206) AND (Pedido = 51433163) |
| 1410042 | online | wserv-20i:54955 | dblojapr | Sleep | 0 | | NULL |
| 1410043 | online | wserv-18i:54139 | dblojapr | Sleep | 0 | | NULL |
| 1410044 | online | wserv-20i:54956 | dblojapr | Sleep | 0 | | NULL |
| 1410045 | online | wserv-18i:54140 | dblojapr | Query | 0 | NULL | Select Perfil from loja Where Loja_id = '154' |
| 1410046 | online | wserv-17i:54026 | dblojapr | Sleep | 0 | | NULL |
| 1410047 | online | wserv-17i:54027 | dblojapr | Query | 0 | NULL | SELECT Catalogo FROM car WHERE (Ped_loja = 114) AND (Pedido = 43237915) |
| 1410048 | online | wserv-18i:54143 | dblojapr | Query | 0 | NULL | SELECT r.Revendedor_id FROM perfil_revendedor r, car_perfil c WHERE c.Pedido = 45847711 |
| 1410049 | online | wserv-18i:54144 | dblojapr | Sleep | 0 | | NULL |
+---------+--------+-----------------+----------+---------+------+-------+-----------------------------------------------------------------------------------------+
2) Processos: veja que só existe UM processo para o mysql
$ ps -efl | grep mysql
0 S hpechman 12568 11627 0 77 0 - 12783 pipe_w 15:54 pts/0 00:00:00 grep mysql
4 S root 27023 1 0 76 0 - 13203 wait Nov24 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log
4 S mysql 27059 27023 76 76 0 - 210610 ? Nov24 ? 1-10:07:30 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/home/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment