This month is a special month. It’s not because of Valentines day or even the exciting day where we see groundhogs. No, this month is special because I’m have a book contest where you, the reader, get to win something free for doing absolutely nothing more than posting a comment saying that you want one of the several books I ha [...]
Posts in category Uncategorized
Win a free book at the February Pytho...
This month is a special month. It’s not because of Valentines day or even the exciting day where we see groundhogs. No, this month is special because I’m have a book contest where you, the reader, get to win something free for doing absolutely nothing more than posting a comment saying that you want one of the several books I ha [...]
Easy Python: multi-threading MySQL qu...
There are many times when writing an application that single threaded database operations are simply too slow. In these cases it’s a matter of course that you’ll use multi-threading or forking to spawn secondary processes to handle the database actions. In this simple example for Python multi-threading you’ll see the how s [...]
DDR-Drive gets 300,000 IOPS
Sure it’s expensive and hard to justify for most budgets but this is the future of drive technology happening now. http://www.ddrdrive.com
themattreid – RSS change –...
Update for all of the RSS subscribers of this site: please update your RSS feed to the new feedburner address: http://feeds.feedburner.com/Themattreid?format=xml
I’ll keep the original feed link active for a while but please change to the new one when you get a chance. Oh, why not just do it now since you’re on the internet and [...]
Update: OSS MySQL Monitoring Solution
Progress on the Open Source enterprise grade MySQL monitoring system; the schema for Monolith version 2 has been designed. Due to the many suggestions for features and the interest it has received I’ve put this on the front burner. That said, here is some more info on the next steps I’ll be taking.
Monitored servers will use a [...]
Request: What do you want in a OpenSo...
What would you like to see in a free enterprise-grade monitoring system for your daily MySQL needs?I’m rewriting Monolith – MySQL DBA Console from the ground up. This will be version 2 and I would like to get some input from the global MySQL community.So far I am going with the following; comment with any improvements/additions. [...]
The Rack
Everyone likes pictures and everyone loves pictures of server racks. This is my development environment at the home office. Consisting of top to bottom. Then there’s a pic of my desk. Gotta love the 32″ HDTV.
Sun v40z – workstation via VNC / FreeNX
SGI 1200 – MySQL master
3com 24port GigE switch
Compaq DL360 – [...]
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:: [...]
Standard Issue
Some common issues I run into.
1. Disk space usage – usually a result of binary logs hogging up space. Usually alleviated by setting expire_logs_day=n but in some cases the server sees so much traffic it can fill up before n days is reached. Hence the usual method of “mysql> purge master logs to ‘log-name.xxx’; [...]
