Incorrect MySQL status variables used to graph "MYSQL PROCESSLIST"

[GoogleCodeExporter]

Dear sir,

Bash script "ss_get_mysql_stats.php" used to collect MySQL status information 
are coded with incorrect MySQL variables.

Therefore, "MySQL Processlist" graph is wrongly getting the information from 
this script.

For example, this bash script runs a MySQL command  
(SHOW /*!50002 GLOBAL */ STATUS);
and trying to map the results to an existing arry of values, but most of the 
values defined in this array are incorrect, 
for example: a State_updating value define as follow
'State_updating'             => 'de'
,since there is no MySQL variable with such name, the "MySQL Processlist" graph 
always shows that there is no "State_updating" counts.

And running the script to query for this specific variable always returns -1:

root# /usr/bin/php -q /var/www/cacti/scripts/ss_get_mysql_stats.php --host 
10.1.14.166 --items de ;
de:-1

Original issue reported on code.google.com by nickelba...@gmail.com on 12 Feb 2012 at 6:44