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, fwrite, random read, pread ,mmap, aio_read, and aio_write. For that I would recommend using Iozone. It gives you a better idea of what’s going on.

http://www.iozone.org

 

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 need to restore it.

shell> mysql <database> < outputfile.sql

more info: http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html