- The graphs are missing "max" "average" "current" data for the counters above them which are quite helpful.
I tried to have those in there, but for some reason, when I put them in, I get no values. Since it's a lot of work to put them in for no values, I didn't put them in. Maybe it's a bug, maybe I did something stupid. Please feel free to add them to one or two graphs, and if it works for you, I'm sure we'd all really appreciate your help. :)
- The axis are marked as 1.0e+1 etc (in my case) which is kind of ugly. I have not yet found a way to fix it.
Edit each graph template and uncheck the "logarithmic" checkbox.
- Innodb data is mixing (yes I know it is inconvenient to dig it from SHOW INNODB STATUS)
Peter Zaitsev, the MySQL tuning guru, has sent me a patch to mysql_stats.php that parses out the SHOW INNODB STATUS. Now it's on my list of things to do to create graphs for all this data. If you download the current XML file, you'll notice data input methods for the various InnoDB stats! Yay Peter!
- If somehow mysql user info is to be entered only once per host adding it for each graph is inconvenient.
It's a limitation of Cacti. I want to edit the mysql_stats.php to have a default username/password, then if your Cacti monitoring username/password is the same everywhere in your cluster, you could just not enter that information and it'd work.
But yes, I find it very annoying that for every host I add (tens) I have to type the same two values over and over. Thank goodness for Firefox and its autocomplete. On the second host and beyond, I just type <downarrow><downarrow><tab> over and over 30 times until I get down to the bottom.