How can I calculate the total time my MySQL database is spending
Waiting for query cache lock ?
I've found two specific very simple tables that adding a SQL_NO_CACHE drastically improved the SELECT queries on them, and I want to analyze other tables in a more methodological approach.
My MySQL version is 5.5.15 and the InnoDB engine is 1.1.8
Query cache size is 536870912