← Back to team overview

maria-discuss team mailing list archive

Re: Statistics/Counters for number SHOW INDEX FROM queries

 

Hi, Markus!

On Jan 21, Markus Uckelmann wrote:
> Hi all,
> 
> We have a lot of SHOW INDEX FROM queries coming from our ORM layer.
> Usually there is a mechanism to prevent this but it doesn't seem to work
> at the moment. To better analyze the problem it would be helpful if we
> could see how many such queries happened on a server. Is there a counter
> or a statistic which can provide us this information?
> We use MariaDB 5.5.

Yes. Watch the status variable Com_show_keys

Regards,
Sergei


Follow ups

References