What does the MySQL Query cache Hitrate % value respesent?

mysql mysql-management query-cache
Chris picture Chris · Feb 4, 2011 · Viewed 10.7k times · Source

Using MySQL Workbench I am looking at the Admin view for two servers I run.

Both servers have a similar bandwidth

On one server there is just one site it has a Query Cache Hit Rate of 15%

The other server has over 100 sites and 88 databases and has a Query Cache Hit Rate of 70%

I'm in the middle of learning about how best to optimise and increase the performance of these MySQL servers and can't find anything about what these values mean, what's good or bad and how they can be improved.

(I've searched a lot, but guess I haven't searched with the right terms)

Answer

Bjoern picture Bjoern · Feb 4, 2011

From here:

The hit rate indicates the ratio of queries that were cached and queries that were not cached.

A high percentage certainly is an indication for an optimized setup, but there are other factors to be taken into care, too.

Related questions

ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost'

I seem to be unable to re-create a simple user I've deleted, even as root in MySQL. My case: user 'jack' existed before, but I deleted it from mysql.user in order to recreate it. I see no vestiges of …

Read More
How to set root password to null

How can I change the password for root user of MySQL to null -- meaning no password or '' -- from the MySQL command line client?

Read More
mysql command for showing current configuration variables

Can not find a command that displays the current configuration of mysql from within the database. I know I could look at /etc/mysql/my.cnf but that is not what I need.

Read More