「Mysql/管理系」の版間の差分
提供: 初心者エンジニアの簡易メモ
(→実行中sql確認) |
|||
行8: | 行8: | ||
+----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+ | +----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+ | ||
| 3 | root | localhost | NULL | Sleep | 1055 | | NULL | | | 3 | root | localhost | NULL | Sleep | 1055 | | NULL | | ||
− | | 7 | root | localhost | NULL | Query | 0 | starting | show processlist | | + | | 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 | | + | | 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 | |
+----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+ | +----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+ |
2017年1月25日 (水) 17:57時点における最新版
容量確認
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 | +----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+