facebook twitter hatena line email

Mysql/管理系

提供: 初心者エンジニアの簡易メモ
移動: 案内検索

容量確認

show table status from DB名;

実行中sql確認

show processlist
----------------------------------------------------------------------+
| Id | User  | Host            | db                  | Command | Time | State    | Info                                                                                                 |
+----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
|  3 | root  | localhost       | NULL                | Sleep   | 1055 |          | NULL                                                                                                 |
|  7 | root  | localhost       | NULL                | Query   |    0 | starting | show processlist                                                                                     |
|  8 | root  | localhost       | table1 | Query   |    1 | update   | INSERT INTO `logs` VALUES ('2017-01-16 22:00:00',6,0,108,15,0,8,0.0,0,0 |
+----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+