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 http://code.google.com/p/google-mysql-tools/ You can read about these here http://www.mysqlperformanceblog.com/2008/10/20/improved-innodb-rw_lock-patch/ Ewen On Tue, Dec 16, 2008 at 4:44 AM, xufeng <xuf...@yuanjie.net> wrote: > Hi > > Is there a way to check if my MySQL5.0.67 works well on SMP? > I have two CPUs with each two cores, and I want to know if MySQL distributes > loads over the two CPUs. > System OS: Linux 2.6.9-42.ELsmp > MySQL Version: 5.0.67 > Intel(R) Xeon(TM) CPU 3.00GHz * 2 > > Thank you in advance. > > Yours, > Xu Feng > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=ewen.fort...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org