RE: MySQL 5.0.67 on SMP

2008-12-16 Thread xufeng
Yes,I tested from two mysql clients with your code and it showed exactly as you pointed out. The top from the mysqld machine showed: Cpu0 : 100.0% us, 0.0% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si Cpu1 : 0.3% us, 0.0% sy, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% si Cpu2 :

full text search ft_min_word_len

2008-12-16 Thread Madan Thapa
Hi, When I use ft_min_word_len=3 under [mysqld] section, mysql fails to start. ft_min_word_len=3 parameter has been added under [myisamchk] only , which works. mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline 5.1 Anyone know about this?

Re: MySQL 5.0.67 on SMP

2008-12-16 Thread Joerg Bruehe
Hi all, xufeng wrote: > Hi fire9, > Thank you for your reply. > Do you have some official document on "MySQL 5.0.67 not supporting SMP"? > If so, would you please give me some info on how to get the smp patches? > > Yours, > Xu Feng > > > > > From: fir

Re: MySQL 5.0.67 on SMP

2008-12-16 Thread ewen fortune
Hi, I think the known problems with MySQL and SMP architecture are more based on storage engine restrictions, so InnoDB for example does not scale well beyond say 8 cores. There are a number of patches to help solve some of these scaling problems. http://www.percona.com/docs/wiki/release:start ht