Waiting for table level lock on wordpress site We are experiencing issues with mySQL loading 100% of the server's CPU. While checking the running processes we found many of the following:

Waiting for table level lock | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'


The table is configured to MyISAM.

Any suggestion of how to optimize mysql?
I had this problem and added an index to wp_option.option_name