Mysql – Zabbix: What does “Questions” mean in “MySQL Command Counters”

MySQLzabbix

I have Zabbix monitoring a MySQL server, the MySQL Command Counter chart is nice, but a large portion of the graph shows massive Questions, Unlike SELECT or INSERT, what does Question mean in MySQL & Zabbix?

Best Answer

According to the docs at http://www.zabbix.com/documentation/1.8/manual/cookbook/specific, "questions" appears to be just a total of any queries (including SELECT, INSERT, etc.).

Related Solutions

Does Zabbix sum data over a period

If you define a graph (as opposed to just clicking on an item and seeing the adhoc graph) you can specify that an item should be shown as its MAX value for the period represented by each pixel.

But if you are storing deltas (count per second) for things like traffic counters, printer page counters, etc., then you can also just use AVG and then do the following:

When you want to know the total for a period of time, graph the item over that period using an adhoc graph
- Look at the average over the period (printed on the graph), and then multiply by the number of seconds in the period

Linux – zabbix monitoring thesql database

FIXED

{$MYSQL_SOCKET1} = /var/lib/mysql/mysql2.sock

i removed the single quotes from the line and it worked...

Best Answer

Related Solutions

Does Zabbix sum data over a period

Linux – zabbix monitoring thesql database

Related Topic