网站数据库经常坏表。MYISAM。
下面是表的一些信息,请大家帮我分析一下。mysql> show processlist;
+--------+-------------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-------------+-----------+------+---------+------+-------+------------------+
| 132342 | witdeals_db | localhost | NULL | Query | 0 | NULL | show processlist |
+--------+-------------+-----------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)mysql> show status like 'table%';
+-----------------------+---------+
| Variable_name | Value |
+-----------------------+---------+
| Table_locks_immediate | 5326133 |
| Table_locks_waited | 1886 |
+-----------------------+---------+
2 rows in set (0.00 sec)mysql> show variables like 'cncurrent_insert';
Empty set (0.00 sec)
下面是表的一些信息,请大家帮我分析一下。mysql> show processlist;
+--------+-------------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-------------+-----------+------+---------+------+-------+------------------+
| 132342 | witdeals_db | localhost | NULL | Query | 0 | NULL | show processlist |
+--------+-------------+-----------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)mysql> show status like 'table%';
+-----------------------+---------+
| Variable_name | Value |
+-----------------------+---------+
| Table_locks_immediate | 5326133 |
| Table_locks_waited | 1886 |
+-----------------------+---------+
2 rows in set (0.00 sec)mysql> show variables like 'cncurrent_insert';
Empty set (0.00 sec)
+-----------------------------------+-----------+
| Variable_name | Value |
+-----------------------------------+-----------+
| Aborted_clients | 122 |
| Connections | 142312 |
| Innodb_buffer_pool_read_requests | 19803 |
| Innodb_data_read | 3657728 |
| Key_blocks_unused | 422645 |
| Key_blocks_used | 13105 |
| Key_read_requests | 751560908 |
| Key_reads | 13139 |
| Key_write_requests | 402172 |
| Key_writes | 126855 |
| Last_query_cost | 10.499000 |
| Open_tables | 492 |
| Opened_files | 1763575 |
| Qcache_free_blocks | 20614 |
| Qcache_free_memory | 92992704 |
| Qcache_hits | 23411531 |
| Qcache_inserts | 2641355 |
| Qcache_lowmem_prunes | 58676 |
| Qcache_not_cached | 644923 |
| Qcache_queries_in_cache | 31005 |
| Qcache_total_blocks | 82762 |
| Queries | 28472677 |
| Table_locks_immediate | 5744373 |
| Table_locks_waited | 2277 |
| Uptime | 444919 |
| Uptime_since_flush_status | 444919 |