18 May
2013
18 May
'13
9:07 a.m.
Hi, Ian! On May 17, Ian Gilfillan wrote:
I'm documenting the status variables at the moment, and have a question about Empty_queries vs Com_empty_queries.
Com_empty_queries is not incremented when an empty result is returned, and appears to be incremented only when an empty query is sent to the server, eg:
mysql --comments -e '-- sql comment'
Yes.
Empty_queries appears to match the empty queries returned with SHOW USER_STATISTICS. It increments each time a query is performed that returns an empty result.
Right. Regards, Sergei