Tuesday, 23 January 2007

MyStatsQL - Easy temporal stats gathering of MySQL server(s)

To make life a little easier at home and work I've put together a simple enough script that is run by cron to tally up statistics like: Innodb_data_reads, Innodb_data_writes, Qcache_hits, Qcache_inserts, Questions, Open_files and Open_tables over time (I sample every hour) with the ability to easily expand and add your own `show status` variables.

Next I'll create some nice graphical interface so it's more obvious how the server or cluster is running. You can grab the script over at my CV hosting. Note that actual client writes in a master <-> master environment would be (writes / number of servers) roughly, very roughly. If you have any ideas for countering this please let me know.

Enjoy.

No comments: