I'm looking to tune my query cache a bit. According to 22.214.171.124. Query Cache Status and Maintenance in the manual:
The Com_select value is given by this formula: Qcache_inserts + Qcache_not_cached + queries with errors found during the column-privileges check
However in 5.1.5. Server Status Variables it suggests that this is maintained by the DBMS. Having said that
mysql> show status like 'Com_select%';
Always returns a value of 1 - and I'm pretty sure I've run more than one non-cached select query on my database since it started.
It looks as if other people are similarly confused.
Is this status variable redundant? Which bit of the manual is wrong?