Version 1.1.3 of improved Cacti graphs for MySQL releasedSat, Oct 24, 2009 in Monitoring Databases Programming
I’ve just released version 1.1.3 of the Cacti templates I wrote for MySQL. This is a bug-fix release only, and affects only ss_get_mysql_stats.php. To upgrade from the previous release, upgrade ss_get_mysql_stats.php. Don’t forget to save and restore your configuration options, if any. (Note that there is a feature to help with this: you can keep configuration options in ss_get_mysql_stats.php.cnf to avoid making them in ss_get_mysql_stats.php.)
VividCortex is the startup I founded in 2012. It’s the easiest way to monitor what your servers are doing in production and I consider it far superior to Cacti. VividCortex offers MySQL performance monitoring and PostgreSQL performance management among many other features.
Next up: actual template changes! More graphs!
The changelog follows.
2009-10-24: version 1.1.3 * This is a bug-fix release only, and contains no template changes. * To upgrade from the previous release, upgrade ss_get_mysql_stats.php. * MySQL 5.1 broke backwards compatibility with table_cache (issue 63). * Added a version number to the script (partial fix for issue 79). * Added a test suite (issue 76, issue 59). * Math operations were done in MySQL instead of PHP (issue 25). * SHOW STATUS values didn't override SHOW INNODB STATUS parsing (issue 24). * Long error messages were not appearing in the Cacti log. * SHOW INNODB STATUS parsing for unpurged_txns was broken. * SHOW INNODB STATUS parsing for innodb_lock_structs was broken. * SHOW INNODB STATUS parsing for pending_log_flushes was broken (issue 62). * SHOW INNODB STATUS parsing for pending_buf_pool_flushes was broken. * SHOW INNODB STATUS parsing for pending_ibuf_aio_reads was broken. * SHOW INNODB STATUS parsing for pending_aio_log_ios was broken. * SHOW INNODB STATUS parsing for pending_aio_sync_ios was broken. * Made SHOW INNODB STATUS parsing less sensitive to false positive matches.
About The Author
Baron is the founder and CEO of VividCortex. He is the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. Baron contributes to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.