Blog
What’s new in MySQL 5.4.1
Absolutely nothing? 5.4.0 was released with a change in the MySQL Binary distributions , delivering only 1 64bit Linux platform and two Sun Solaris platforms. This was officially announced on April 21 2009 however the 5.
Read moreWhat to do at 3:25am
Look at MySQL bug reports of course? Well actually I’m writing multiple blog posts, and I was confirming additional reference sources and links when I came across MySQL Bug #29847 – Large CPU usage of InnoDB crash recovery with a big buf pool.
Read moreNever let your binlog directory fill up
Recently with a client while running a number of disaster recovery tests I came across a nasty situation which was not part of the original plan and provided a far worse disaster situation then expected.
Read moreGetting wireless working on Ubuntu Macbook
I run Ubuntu 9.04 Januty on my Macbook. Previously installing Ubuntu 8.10, wireless worked automatically, for 9.04 it did not. This is what I did to fix it. Verify your Macbook is seeing the Broadcom controller.
Read moreUnderstanding InnoDB MVCC
Multi versioning concurrency control (MVCC) is a database design theory that enables relational databases to support concurrency, or more simply multiple user access to common data in your database. In MySQL the InnoDB storage engine provides MVCC, row-level locking, full ACID compliance as well as other features.
Read moreKilling my softly with QUERY
The MySQL KILL command as the name suggests kills queries that are running. After identifying the Id using the SHOW PROCESSLIST command, the User of the connection/thread or a database user with SUPER privileges can execute KILL [id]; to remove the connection/thread.
Read moreInstalling Perl RRD module – RRDs.pm
Perform a quick check if the module is available. $ perl -MRRDs -le 'print q(ok!)' Can't locate RRDs.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.7/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.
Read moreAn important Drizzle/MySQL difference
There are many features that are similar in MySQL and Drizzle. There are also many that are not. I’ve previously discussed topics like Datatypes and tables , SQL_MODE and SHOW .
Read moreThe confusion over global and session status
I was trying to demonstrate to a client how to monitor queries that generate internal temporary tables. With an EXPLAIN plan you see ‘Creating temporary’. Within MySQL you can use the SHOW STATUS to look at queries that create temporary tables.
Read moreBenchmarking Drizzle with MyBench(DBD::drizzle)
With thanks to Patrick Galbraith and his DBD::drizzle 0.200 I am now able to test client benchmarks side by side with MySQL and Drizzle. For simple benchmarking with clients, generally when I have little time, I use a simple Perl framework mybench .
Read moreVerifying MySQL Replication in action
There is a very simple test to show MySQL replication in action and to also better understand the basics of MySQL Replication. With a configured MySQL environment we can run the following test on your MySQL master, and monitor the MySQL slave.
Read moreMiFi Installation woes
As I mentioned in MiFi Introduction I took the plunge and purchased a Verizon MiFi . I got this under a 2 year contract for $149.99 and $59.99 per month for 5GB of traffic.
Read moreMiFi Introduction
My first news of the Verizon MiFi was via Twitter when @DonMacAskill said “Think my iPhone 3G via MiFi is faster than AT&T 3G. Should I carry both all the time now?
Read more