I'm trying to troubleshoot my MYSQL in a LAMP and have an interesting situation. At first I thought MYSQL itself was locking up, but it turns out to be ONLY innodb databases that are locking up.
These sites are WordPress. I converted one to Myisam and now when the lockups happen that one is still good, so in my mind this rules out site specific issues.
Any suggestions?
This is my my.cnf
[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
query_cache_size=128M
tmp_table_size=32M
thread_cache_size=4
innodb_buffer_pool_size=400M
key_buffer_size=60M
max_heap_table_size=32M
tmp_table_size=64M
join_buffer_size=1M
mytop
ormysqladmin processlist
in a while loop to try and catch the queries in the act. – Stefan Lasiewski Dec 25 '14 at 21:42