网站数据库经常坏表。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)
请问,换成innodb可以避免上述的问题吗?