Re: Mysql hangs once in 2 days with mysterious deadlock?

[Hankin Chick]

The biggest table has 128 partitions.

> SELECTs and UPDATEs can take a long time -- other connections can collide with them.

Would it help if I locked the table before doing any updates/inserts?



mysql> SHOW VARIABLES LIKE 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| innodb_file_per_table | ON |

mysql> SHOW VARIABLES LIKE '%open%';

| have_openssl | DISABLED |
| innodb_open_files | 300 |
| open_files_limit | 16384 |
| table_open_cache | 256 |
+-------------------+----------+
mysql> SHOW VARIABLES LIKE 'autocommit';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit | ON |



Thank you!