Monthly Archives: September 2007

Capture DB2 long running SQL

DB2 (LUW) V8 and higher has a couple of things that annoy me when it comes to performance tuning. The first is the obtrusive nature of the event monitor. To guarantee you capture all the sql statements running in an … Continue reading

Posted in db2, Other dbs, performance, script | Comments Off on Capture DB2 long running SQL

Server Performance and the Database

I am cleaning out some old scripts and it got me thinking back to a time before I rejoined the ranks of consultant… to many different jobs and many different people. Why is it that some companies or “tech” people … Continue reading

Posted in hardware, Other dbs, performance, rant, script | Comments Off on Server Performance and the Database

Interesting and wacky stuff with XFS and EXT3

Some debate on whether XFS or EXT3 is better for mysql performance. I have heard arguments for both. I was benchmarking some myisam to innodb conversions today and thought I would try the same benchmarks using ext3 and with xfs… … Continue reading

Posted in linux, mysql, performance | Comments Off on Interesting and wacky stuff with XFS and EXT3

Fun stuff Coming up

While I am waiting for some benchmarks to finish I thought I would post a little bit here and there. Something interesting to note I have a full plate of travel ahead of me, Traveling to Madison WI, Chicago, and … Continue reading

Posted in fantasy sports, personal, rant | Comments Off on Fun stuff Coming up

Passed DBA I

I took and passed the DBA I exam about a week ago!  Onto study for DBA II!

Posted in Uncategorized | Comments Off on Passed DBA I

MyIsam + Heartbeat failover goodness

Was out a client last week putting in a heartbeat based HA solution riding over top of myisam. Not a typical HA solution, and one that DRBD is not going to be a preferred component of the tech stack.  We … Continue reading

Posted in HA, linux, mysql | Comments Off on MyIsam + Heartbeat failover goodness

Another disk benchmarking tool

A tool I have used in the past in place of bonnie++ is Orion from Oracle. I like how it flexes different kinds of io load ( oltop, olap) against your disk. maybe I will try it with my ramdisk … Continue reading

Posted in links, oracle, performance, raid | Comments Off on Another disk benchmarking tool

VMWARE, Software Raid, and my server

Yesterday I reinstalled ubuntu on my linux server here at home. Interesting stuff, ran into all kinds of problems using gutsy with vmware. Followed the standard vmware install procedures for ubuntu ( run the installer, stop before the config and … Continue reading

Posted in hardware, linux | Comments Off on VMWARE, Software Raid, and my server

Interesting tool out there

http://www.fr3nd.net/projects/mysqlpdump/ This allows a mysqldump to be broken up into multiple files, and lets you multi-thread the dump process. Worth checking out!

Posted in links, mysql, script | 1 Comment

Datatype fun…

Its truely amazing how in mysql datatype changes can make a huge performance benefit. Some common ones, changing doubles to decimals can save 4-7 bytes per column, per row… See: http://dev.mysql.com/doc/refman/5.1/en/precision-math-decimal-changes.html & http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html the same can be said for timestamp … Continue reading

Posted in mysql | Comments Off on Datatype fun…