We have traditions in our family but Thanksgiving was never one of those holidays that we were fanatic about. We always had a turkey dinner, but sometimes it was at our house, sometimes we went to other relatives or friends, we have even gone out to dinner for Thanksgiving on occasion. When I moved out…
Month: November 2011
Using Iozone for Filesystem Benchmarking
If you have been around computer systems long enough everyone knows how import disk performance is, espeacially with database systems. There’s the standard htparm -tT and dd test the everyone does, but it really does give you the whole picture. What you really want is to test read, write, re-read, re-write, read backwards, read strided, fread,…
Using Mysqldump to Backup Your Stored Procedures, Functions and Triggers
Now that MySQL has Stored Procedures, Functions and Trigger. I have found myself needing to back them up or make copies to move to a different MySQL server. It’s actually pretty easy to do with mysqldump. Here is the command line for it. shell> mysqldump –routines –no-create-info –no-data –no-create-db –skip-opt <database> > outputfile.sql Then if you…
Queen of Seattle Paddle Wheel
I like family adventures, taking the boys places that they haven’t been before and hopefully somewhere that my husband and I will enjoy as well. When I saw the Groupon for the Queen of Seattle paddle wheel cruise I knew this would be one of those good family adventures. The boys loved going on a paddle wheel…