Count/Statistic for number of SHOW INDEX queries in MySQL/MariaDB 5.5 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.
Found it:

# mysql -e "show global status like 'Com_show_keys';"
+---------------+----------+
| Variable_name | Value    |
+---------------+----------+
| Com_show_keys | 12776476 |
+---------------+----------+`