「Mysql/管理系」の版間の差分
提供: 初心者エンジニアの簡易メモ
(ページの作成:「==容量確認== show table status from DB名;」) |
|||
| 行1: | 行1: | ||
==容量確認== | ==容量確認== | ||
show table status from DB名; | 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 | | ||
| + | +----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+ | ||
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 |
+----+-------+-----------------+---------------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
