Tag Archives: 5.0

5.0 journal: various issues, replication prefetching, our branch

Posted on 2008/06/07 by

First of all, I have to apologize about some of my previous remark on 5.0 performance. I passed ‘-g’ CFLAGS to my build, and that replaced default ‘-O2′. Compiling MySQL without -O2 or -O3 makes it slower. Apparently, much slower. … Continue reading →

Posted in mysql, wikipedia, wikitech | Tagged , , , , , | 8 Comments

5.0

Posted on 2008/05/26 by

I’m trying to run 5.0. Even Mark said he EOL’ed 4.0. Anyway, the upcoming journey will be very fun, and I’ll try writing down some notes here.

Posted in mysql | Tagged

MySQL 5.0 optimizer: loose scans

Posted on 2005/12/17 by

MySQL 5.0 among lots of visible features, introduced several neat optimizer improvements, that may give surprising performance in some queries. Loose index scan, or rather index jumping, allows fast aggregate max() or min() operations, as well as distinct row queries. … Continue reading →

Posted in mysql | Tagged , | 3 Comments