MySQL com_select Nugget

The com_select counter isn’t a raw count of how many SELECT operations the server has performed, but rather the number of SELECT operations that did not get returned from the query cache. To see the real number of SELECTs (assuming query caching is on), you need com_select + qcache_hits.

This is in MySQL’s documentation, but I thought I’d share.

This entry was posted in Linuxy, Work. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *