facebook twitter hatena line email

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