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.
I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.