search

jasonholtzapple / check_mysql_counters

MySQL Performance Graphs with pnp4nagios
16 stars 10 forks source link

Modified check_mysql_counters_55 for MySQL 5.5.29 #1

Closed chrisldice closed 10 years ago

chrisldice commented 11 years ago

MySQL 5.5.29 returns different variables from the ones listed, causing the "Undefined offset: 311" issue. This template has the right offsets for the variables in this version.

jasonholtzapple commented 11 years ago

The output that I've received from others running MySQL 5.5 doesn't match yours. What platform are you running on? Could you send me the output of these commands?

SELECT VARIABLE_VALUE FROM GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'VERSION' SELECT * FROM INFORMATION_SCHEMA.GLOBAL_STATUS SELECT VARIABLE_NAME, VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE _NAME = 'MAX_CONNECTIONS' OR VARIABLE_NAME='QUERY_CACHE_SIZE' OR VARIABLE_NAME='TABLE_OPEN_CACHE' ORDER BY V ARIABLE_NAME

jasonholtzapple commented 10 years ago

closing for lack of response