LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 03-30-2009, 10:42 AM   #1
nino_of_qubic
LQ Newbie
 
Registered: Mar 2006
Location: North Carolina
Distribution: Open Suse
Posts: 17

Rep: Reputation: 0
configuring MYSQL 5.0.67 to use multiple cores (processors)


Hello,

I run OpenSUSE 11.1 (64 bit) / MYSQL 5.0.67 to power a web site. The site uses several small queries that keep one core very busy. I recently upgraded to a quad-core machine, and I would like to set the system to use at least 2 of the 4 cores.

Any suggestions?
 
Old 03-31-2009, 11:01 AM   #2
archangel_617b
Member
 
Registered: Sep 2003
Location: GMT -08:00
Distribution: Ubuntu, RHEL/CentOS, Fedora
Posts: 234

Rep: Reputation: 42
Quote:
Originally Posted by nino_of_qubic View Post
Hello,

I run OpenSUSE 11.1 (64 bit) / MYSQL 5.0.67 to power a web site. The site uses several small queries that keep one core very busy. I recently upgraded to a quad-core machine, and I would like to set the system to use at least 2 of the 4 cores.

Any suggestions?

MySQL will automatically use multiple cores. Individual queries are not split across many cores, but if you've got many queries in parallel, then it will. If it's not doing so, look at how you're doing the queries, I think it's more likely that the server cannot execute them in parallel.

- Arch
 
Old 03-31-2009, 10:04 PM   #3
nino_of_qubic
LQ Newbie
 
Registered: Mar 2006
Location: North Carolina
Distribution: Open Suse
Posts: 17

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by archangel_617b View Post
MySQL will automatically use multiple cores. Individual queries are not split across many cores, but if you've got many queries in parallel, then it will. If it's not doing so, look at how you're doing the queries, I think it's more likely that the server cannot execute them in parallel.

- Arch
Thank you for your reply.

Do you know of a good test to see the system is capable and just not configured correctly?

- Nino
 
Old 03-31-2009, 11:29 PM   #4
archangel_617b
Member
 
Registered: Sep 2003
Location: GMT -08:00
Distribution: Ubuntu, RHEL/CentOS, Fedora
Posts: 234

Rep: Reputation: 42
Quote:
Originally Posted by nino_of_qubic View Post
Thank you for your reply.

Do you know of a good test to see the system is capable and just not configured correctly?

- Nino

I haven't used any mysql, just search for MySQL performance testing tools. First hit I saw was for something called "supersmack". I know that for the main mysql server where I work it will often fully utilized two cores so it's been working for us.

- Arch
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quad processor cores vs. 4 processors. mandrakethepenguin Linux - Hardware 12 08-14-2008 03:05 PM
how does the OS handle multiple processors? mkrems Linux - General 3 05-01-2008 09:20 PM
LXer: Take advantage of multiple CPU cores during file compression LXer Syndicated Linux News 0 02-13-2008 08:40 PM
linux on multiple cores reslowgr Linux - Server 1 01-20-2007 03:35 PM
Multiple Processors KneeLess Linux - Hardware 1 08-22-2003 08:23 PM


All times are GMT -5. The time now is 02:04 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration