[Maria-discuss] Statistics/Counters for number SHOW INDEX FROM queries
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. Cheers, Shorty
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
Am 21.01.2014 17:08, schrieb Sergei Golubchik:
Hi, Markus!
Hi Sergei,
Yes. Watch the status variable Com_show_keys
Thanks, that did the trick. # mysql -e "show global status like 'Com_show_keys';" +---------------+----------+ | Variable_name | Value | +---------------+----------+ | Com_show_keys | 12776476 | +---------------+----------+ I guess, there's some work ahead... ;) Cheers, Markus
12776476!? how many hours online? 2014/1/21 Markus Uckelmann <shorty@koeln.de>
Am 21.01.2014 17:08, schrieb Sergei Golubchik:
Hi, Markus!
Hi Sergei,
Yes. Watch the status variable Com_show_keys
Thanks, that did the trick.
# mysql -e "show global status like 'Com_show_keys';" +---------------+----------+ | Variable_name | Value | +---------------+----------+ | Com_show_keys | 12776476 | +---------------+----------+
I guess, there's some work ahead... ;)
Cheers, Markus
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial
participants (3)
-
Markus Uckelmann -
Roberto Spadim -
Sergei Golubchik