Turn off the hyperthreading. You're not going to see superior performance
with hyperthreading enabled, you're just going to create a massive
thread-thrash with 16 logical cpus running 16 threads with not nearly enough
resources to cover them.
----- Original Message -----
From: "Christian Hammers" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, August 22, 2006 6:47 AM
Subject: How to utilize 16 logical CPUs
Hello
I have a server with the following specs but fear that the currently
running MySQL-4.1 does not completely utilize it as the database feels
to slow for the webservers although the system load is always only at
about 10%:
CPU: Quad Dualcore Xeon with Hyperthreading (4*2*2=16 logical cpus)
Kernel: 2.6.17.6 (-> NPTL threading)
RAM: 16 GB
OS: Debian GNU/Linux 3.1 "sarge" with i386 architecture
Can it be that MySQL-4.1 does not share the load across all CPUs?
Has MySQL-5.0 any improvements for this hardware?
(I know that poor performance can result from inefficient queries and
wrong configuration settings, too, but as this would get quite complex
then I first want to rule out this cause)
thanks,
-christian-
--
Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Systems Partner - Authorized Reseller
Lütticher Straße 10 Tel 0241/701333-11
[EMAIL PROTECTED] D-52064 Aachen Fax 0241/911879
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]