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
Original issue reported on code.google.com by
nickelba...@gmail.com
on 12 Feb 2012 at 6:44