-rw-rw---- 1 mysql mysql 1073742459 Jan 29 22:27 mysql-bin.000001 -rw-rw---- 1 mysql mysql 272303699 Feb 28 18:08 mysql-bin.000002 -rw-rw---- 1 mysql mysql 125 Feb 28 19:13 mysql-bin.000003 -rw-rw---- 1 mysql mysql 125 Feb 28 21:29 mysql-bin.000004 -rw-rw---- 1 mysql mysql 125 Feb 28 22:36 mysql-bin.000005 -rw-rw---- 1 mysql mysql 125 Feb 28 23:33 mysql-bin.000006 -rw-rw---- 1 mysql mysql 125 Feb 28 23:50 mysql-bin.000007 -rw-rw---- 1 mysql mysql 125 Mar 1 19:32 mysql-bin.000008 -rw-rw---- 1 mysql mysql 125 Mar 1 22:10 mysql-bin.000009 -rw-rw---- 1 mysql mysql 125 Mar 1 23:22 mysql-bin.000010 -rw-rw---- 1 mysql mysql 125 Mar 1 23:23 mysql-bin.000011 -rw-rw---- 1 mysql mysql 10098483 Apr 27 22:13 mysql-bin.000012 -rw-rw---- 1 mysql mysql 268132198 May 4 10:24 mysql-bin.000013 -rw-rw---- 1 mysql mysql 247 Apr 27 22:14 mysql-bin.index 有几个日志文件确实挺大.日志清除完毕后,页面打开速度快了1秒到2秒非常感谢zy205817!
这个没查到异常: mysql> show processlist; +------+------+-----------+------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------+------+---------+------+-------+------------------+ | 7249 | root | localhost | NULL | Query | 0 | NULL | show processlist | +------+------+-----------+------+---------+------+-------+------------------+ 1 row in set (0.02 sec)
-rw-rw---- 1 mysql mysql 272303699 Feb 28 18:08 mysql-bin.000002
-rw-rw---- 1 mysql mysql 125 Feb 28 19:13 mysql-bin.000003
-rw-rw---- 1 mysql mysql 125 Feb 28 21:29 mysql-bin.000004
-rw-rw---- 1 mysql mysql 125 Feb 28 22:36 mysql-bin.000005
-rw-rw---- 1 mysql mysql 125 Feb 28 23:33 mysql-bin.000006
-rw-rw---- 1 mysql mysql 125 Feb 28 23:50 mysql-bin.000007
-rw-rw---- 1 mysql mysql 125 Mar 1 19:32 mysql-bin.000008
-rw-rw---- 1 mysql mysql 125 Mar 1 22:10 mysql-bin.000009
-rw-rw---- 1 mysql mysql 125 Mar 1 23:22 mysql-bin.000010
-rw-rw---- 1 mysql mysql 125 Mar 1 23:23 mysql-bin.000011
-rw-rw---- 1 mysql mysql 10098483 Apr 27 22:13 mysql-bin.000012
-rw-rw---- 1 mysql mysql 268132198 May 4 10:24 mysql-bin.000013
-rw-rw---- 1 mysql mysql 247 Apr 27 22:14 mysql-bin.index
有几个日志文件确实挺大.日志清除完毕后,页面打开速度快了1秒到2秒非常感谢zy205817!
这个没查到异常:
mysql> show processlist;
+------+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------+------+---------+------+-------+------------------+
| 7249 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+------+------+-----------+------+---------+------+-------+------------------+
1 row in set (0.02 sec)