-
Recent Posts
Recent Comments
- Harrison on Helping to Organize a MySQL Bootcamp @ IOUG’s COLLABORATE 11
- Mark Callaghan on More Debate, More Flame, More Choosing the correct tool for the job
- Matthew Yonkovit on New Benchmark I am working on that tests MYSQL -vs- NOSQL
- Sam on New Benchmark I am working on that tests MYSQL -vs- NOSQL
- Matt Montgomery on New Benchmark I am working on that tests MYSQL -vs- NOSQL
Archives
- October 2011
- May 2011
- October 2010
- September 2010
- April 2010
- March 2010
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- August 2008
- July 2008
- June 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
Categories
Meta
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
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
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
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
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
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
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
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
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!
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