Hi,
On a real server I have MySQL 5.0.77 and it's working fine.
On my local machine I have installed the latest xampp 1.1.8-beta1 which has MySQL 5.5.25 (and had previously tried 1.1.7 which had MySQL 5.5.16) and I'm experiencing tremendous performance issues on the local machine. Some slightly complex queries that on the real server (old MySQL) take just a few milliseconds to complete, on my local machine (new MySQL) take about 60 seconds at 100% CPU on an identical copy of the database.
So either there is an infamous regression in MySQL somewhere between 5.0.77 and 5.5.16, or there's something in XAMPP or in my machine that is preventing MySQL from working decently.
That's what I want to figure out, so I need to install MySQL 5.0.77 or older on my local machine to work with XAMPP, but I'd like to keep the rest of XAMPP current (i.e. php version, phpmyadmin version, apache version), rather than install an old version of XAMPP altogether.
Is it very complicated to replace mysql with a different version? How would you do that?
thanks in advance
m.