I have been tracking the slow queries log of the WP based site (with the default value of the a long_query_time set to 10), and I have noticed that the following query is often getting logged -
# User@Host: root[root] @ localhost  # Query_time: 0 Lock_time: 0 Rows_sent: 394 Rows_examined: 458 SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
I do not understand how such a small table can take so much time to execute. Is this just a symptom of some other problem? (Currently running Moodle, phpbb and WP on a dedicated VM).