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