Re: MySQL5 performance

[email protected] wrote:
> 
> On Aug 24, 2006, at 15:37, [email protected] wrote:
> 
> > I've just reverted back to php4 & MySQL4 after trying php5 & MySQL5  
> > (all Darwinports).
> >
> > I found that MySQL5 appeared to be substantially slower than  
> > MySQL4. I'm using a php script to trawl through a bunch of text  
> > files, and depending on what it finds in each line to ignore it or  
> > insert or update a db entry.
> >
> > MySQL4 achieves a import in about 1 hour 20 mins, MySQL5 takes  
> > about 3 hours. The php script is identical, the logfiles are  
> > identical, the db structure is identical, the indexes are identical.
> >
> > I've tried searching for tweaks to my.cnf ... made very little  
> > difference ... certainly nothing seems to bring MySQL5 anywhere  
> > near MySQL4's time.
> >
> > There are some forum entries that say about a MacOSX speed bug in  
> > the latest MySQL5, but it doesn't say what version(s) are actually  
> > affected.
> >
> > So any ideas?
> >
> > MacOSX 10.4.7 running on a G4Ti 667 MHz laptop with 1 GB RAM.
> 
> Have you already tried the official Mac OS X binaries available from  
> http://dev.mysql.com instead of using DarwinPorts? Do you observe the  
> same performance differences there, or only with the DarwinPorts  
> compilation?


Not yet. I have dowloaded the 5.0.24 binary for osx10.4-powerpc from mysql.com but haven't yet tried to install it. Depends too how long it'd take me to find all the config-ing options to change.

But I'll try it now.

Mark