← Back to team overview

maria-developers team mailing list archive

Re: Empty_queries vs Com_empty_queries

 

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


References