Tag Archives: 5.0
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
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.
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