mysql tmp下#sql_xxx_0.MYD 类文件占满空间的经历
mysql> show processlist;+------------+-----------------+----------------------+-----------+-------------+----------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------------+-----------------+----------------------+-----------+-------------+----------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
| 1 | event_scheduler | localhost | NULL | Daemon | 54024745 | Waiting on empty queue | NULL |
| 2912394659 | nginxs_rw | 172.17.11.99:12936| nginxs | Execute | 12508 | Sending data | select
month(a.blog_date),
count(distinct b.usname) as android,
count(distinct c.usname) |
| 2912395083 | nginxs_rw | 172.17.11.99:34020| nginxs | Execute | 12051 | Sending data | select
month(a.blog_date),
count(distinct b.usname) as android,
count(distinct c.usname) |
| 2912402122 | root | localhost | nginxs | Query | 0 | init | show processlist |
+------------+-----------------+----------------------+-----------+-------------+----------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
10 rows in set (0.00 sec)
页:
[1]