Re: Help : 4.0.2-alpha slower than 3.23.51 :-(

2002-08-19 Thread Antoine
> Do you use so huge queries that you really need sort_buffer=64M and > record_buffer=32M? Don't forget that record_buffer and sort_buffer are > specified per-thread. I don't know exactly which values I need, but when I generate statistical data from the tables it often spans a not-so-small d

Re: Help : 4.0.2-alpha slower than 3.23.51 :-(

2002-08-19 Thread Egor Egorov
Antoine, Monday, August 19, 2002, 3:57:50 PM, you wrote: A> I have tried to upgrade from MySQL 3.23.51 to 4.0.2-alpha (both source A> distribution, same environment, same compiler, same configuration file) A> and I was puzzled to see that my application became 5 to 10 times slower. A> Most queri

Help : 4.0.2-alpha slower than 3.23.51 :-(

2002-08-19 Thread Antoine
Hi, I have tried to upgrade from MySQL 3.23.51 to 4.0.2-alpha (both source distribution, same environment, same compiler, same configuration file) and I was puzzled to see that my application became 5 to 10 times slower. Most queries in my application (at least the critical part) are write quer