Monthly Archives: October 2007

I decided I want to pull lots of the key information I need to perform query tuning into 1 place. So I started writing a query analyzer tool in perl. So far here is the output: Query: select count(*), end … Continue reading →

I heard something kind of interesting from a client. They were told there was not way to detect locks on innodb tables. Of course I gave them one of those weird looks… I thought I would throw out a couple … Continue reading →

A couple things I do not want to forget. #1. if you are using merge tables, you must create the merge table with the same index definitions.  If you do not the optimizer will choose a full scan over an … Continue reading →