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 |
+----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
