Monthly archives for February, 2008
Basic requirements of production data...
I just need to get some basics off of my chest here, it’s by no means a full list but it’s the most basic list I can think of to start with, and it’s basic because I am surprised by some of the slop I’ve seen in production environments.
1. Highly available server clusters – this is different than load balancing [...]
For the love of god please use the fo...
Let’s begin by assuming you have a server that runs MySQL and lots and lots of traffic flows through it everyday, let’s say… something like 50% of the size of the partition that the mysql binary logs are written to is on, then we will assume the binary log is turned on. Then we assume that expire_logs_days is not set.
What [...]
Monolith MySQL DBA Console – ve...
I’m pleased to announce that after almost one year since the last release, the new version is available. There are many new features this time around. Originally it was titled Monolith MySQL Backup Manager, but because of the new features it has been changed to the new name. You can download here: http://sourceforge.net/projects/monol [...]
Rotating General Query & Slow Lo...
Sometimes you need to have the general query log on and even though it causes more disk I/O than you may want, it’s good for troubleshooting. This log can and probably will fill up your disks rather quickly. Then there’s the slow query log – setting log_slow_queries and log_queries_not_using_indexes will write out the que [...]
More Monolith Graphs
Decided to add some more reporting graphs to the Monlith Monitor. As follows…..
1. Bytes_sent + Bytes_received {graph-data_transfer.php}
2. Open_tables + Created_tmp_disk_tables {graph-tables.php}
3. Created_tmp_files + Created_tmp_tables {graph-tmp_created.php}
4. Threads_connected + Threads_running {graph-threads_now.php}
[...]
