I don't now your application at all. That being said, if you are running a single-threaded application I don't see how MySQL could have more than one thread running on one CPU.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Yoloits [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 19, 2006 1:25 PM > To: mysql@lists.mysql.com > Subject: CPUs not being utilized > > 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. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]