Emergency

Monthly Archives: November 2006

When EXPLAIN can be misleading

One think I can see with people using EXPLAIN is trusting it too much, ie assuming if number of rows is reported by EXPLAIN is large query must be inefficient. It may not be the …

Read More
 

Undo area size restriction needed for Innodb

As you can read from my Innodb Architecture and Performance Optimization presentation Innodb automatically manages undo area in system tablespace so you never need to care about it. I present it as positive feature reducing …

Read More
 

Back from OpenSource Database Conference

I’m just back from OpenSource Database Conference and PHP International Conference which took place in Frankfurt. I’ve uploaded slides for two talks I’ve been giving which you might want to check out. In general Database …

Read More