My mysql 5.1.30 database sometimes gets very bogged down. I have a health checker that does a very simple DB query and usually it takes < 10 ms but during high traffic it can return very slowly (> 1 s).
It could be that I simply have too much IO happening on my disk but the thing that concerns me most is that ‘show innodb status’ frequently displays ‘mysql tables in use 1,locked 1’. Does this in and of itself mean the entire table is locked?
I put more data into a google document: the schema for the table that could be locking, the query that is getting run, iostat, and show table status.
Thank you for all your help!