Hi Group, > I have a new dedicated mysql 4.0.5 server running redhat 8.0 that we are testing. > The new server is a dual Intel Xeon 2.4GHZ with hyperthreading enabled, so Linux > thinks there are 4 cpu's rather than the 2 real CPU's.
I have a similar hardware running mysql 3.23.52 on linux. In my special case mysql has to handle few but very straining queries (running 10-30 seconds). As of my experience, mysql is not able to use both physical processors to process one of these jobs... it really bunches two "virtual" processors (even though top shows 0% load for the 3 remaining processors) but not "physical processor spanning". I would like one single mysql process to make use of all available cpu capacity if no concurrent processes demand attention. But: is this possible using mysql 3.x? Thanks in advance Keith Sauvant --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php