I saw some bad utilization of the query cache on one of my clusters the other day. I haven’t tuned the cache since installing the standard cnf file so let’s take the following usage graph that is output by Monolith.
Queries not cached: 40,000
Queries in cache: 250
Queries not cached: 7500
Queries in cache: 200
In the first ima [...]
Posts in category Monolith
When to tune query cache settings
I saw some bad utilization of the query cache on one of my clusters the other day. I haven’t tuned the cache since installing the standard cnf file so let’s take the following usage graph that is output by Monolith.
Queries not cached: 40,000
Queries in cache: 250
Queries not cached: 7500
Queries in cache: 200
In the first ima [...]
Making Monolith scripts RH Cluster aw...
If you have Monolith installed in a RedHat cluster environment and are wondering how to make the cron job scripts only execute on the active cluster node, this script is a working example. It needs to be installed and running on each cluster node. The only variable to change is “MYHOST” depending on which node the script is runn [...]
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 [...]
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}
[...]
Perl Parallel Processing for data col...
Figured I’d update and say that I solved the issue with threading. (Thanks Steve). The agent.pl script is now using the Proc::Queue module to automatically manage the number of spawned processes via forking. Here’s the run down.
use Proc::Queue;
Proc::Queue::size(10); # changing limit to 10 concurrent processes
Proc::Queue:: [...]
Monolith 1.2 Update
Lots of changes coming down the pipe for the upcoming release.
Changes as follows.
1. Name change – from Monolith MySQL – Backup Manager to Monolith – MySQL DBA Console [pending]
2. Performance auditing, Security Auditing, OLAP tools, Backup management [complete]
3. Parallel server polling for large cluster support [comp [...]
Perl Parallel Processing for data col...
I’ve been wanting to change the Monolith polling (poller.pl) script for a while. It’s written in perl and is called by the agent.pl script. This ideally runs from Cron on hourly or daily intervals – depending on how often you want to collect DB statistics for OLAP needs.
Problem:
I am currently polling >80 servers and [...]
