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.
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