Monthly Archives: October 2007

Working on an interesting new tool (QueryAnalyzer)

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

Posted in mysql, performance | Comments Off on Working on an interesting new tool (QueryAnalyzer)

Innodb lock detection

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

Posted in mysql, performance | Comments Off on Innodb lock detection

MySQL Merge Table & Other stuff

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

Posted in mysql, performance | Comments Off on MySQL Merge Table & Other stuff