Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment