I am running MailWatch with mysql 4.1.20 with Red Hat Enterprise 4 on a dual XEON 3.2 with 4 GB mem. I have the smp kernel loaded so both CPUs are seen. They show up as 4 CPUs. That is the only application the server runs. I moved to this server so I could increase the query speed that was quite slow which is slightly better but it should be faster. It is not using all the CPUs.
When I run a query one of the 4 CPUs is pegged to zero and the other 3 remain at 98 to 100% idle. Can mysql utilize all the CPUs? Or is this a limitation of the application? How can I check to see what the problem is? Have I missed a setting in mysql? Any help or guidance would be appreciated. Jay Ehrhart -- This message has been scanned for viruses and dangerous content by the Yolo County Office of Education MailScanner, and is believed to be clean.
