Образовательный проект «SnakeProject» Михаила Козлова

⇒ SQL\T-SQL ⇐

CISCO

Voice(Asterisk\Cisco)

Microsoft

Powershell

Python

FreeBSD and Nix

1С

Общая

WEB Разработка

ORACLE SQL \ JAVA

Мото

Стрельба, пневматика, оружие

Саморазвитие и психология

MySQL грузит процессор, понять чем

MySQL грузит процессор, понять чем

В момент тормозов заходим на сервер и даем команду

mysql> SHOW FULL PROCESSLIST;
+-------+-------------+-------------------+--------+-------------+------+-----------------------------------------------------------------------------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-------------+-------------------+--------+-------------+------+-----------------------------------------------------------------------------+-----------------------+ | 1 | system user | | NULL | Connect | 534 | Waiting for master to send event | NULL | | 2 | system user | | NULL | Connect | -272 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | | 2176 | slave | 10.10.10.12:38410 | NULL | Binlog Dump | 501 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2854 | slave | 10.10.11.22:20694 | NULL | Binlog Dump | 490 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | | 22797 | root | 127.0.0.1:44600 | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST | | 25400 | banner | localhost | banner | Sleep | 0 | | NULL | +-------+-------------+-------------------+--------+-------------+------+-----------------------------------------------------------------------------+-----------------------+ 6 rows in set (0.00 sec)

mysql> select * from INFORMATION_SCHEMA.PROCESSLIST;
+-------+-------------+-------------------+------+-------------+------+------------------------------------------------------------------+----------------------------------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | +-------+-------------+-------------------+------+-------------+------+------------------------------------------------------------------+----------------------------------------------+ | 22797 | root | 127.0.0.1:44600 | NULL | Query | 0 | executing | select * from INFORMATION_SCHEMA.PROCESSLIST | | 2854 | slave | 10.10.11.22:20694 | NULL | Binlog Dump | 493 | Master has sent all binlog to slave; waiting for binlog to be up | NULL | | 2176 | slave | 10.10.10.12:38410 | NULL | Binlog Dump | 504 | Master has sent all binlog to slave; waiting for binlog to be up | NULL | | 2 | system user | | NULL | Connect | -272 | Slave has read all relay log; waiting for the slave I/O thread t | NULL | | 1 | system user | | NULL | Connect | 537 | Waiting for master to send event | NULL | +-------+-------------+-------------------+------+-------------+------+------------------------------------------------------------------+----------------------------------------------+ 5 rows in set (0.01 sec)

Комментарии пользователей