LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   configuring MYSQL 5.0.67 to use multiple cores (processors) (http://www.linuxquestions.org/questions/linux-server-73/configuring-mysql-5-0-67-to-use-multiple-cores-processors-715512/)

nino_of_qubic 03-30-2009 10:42 AM

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?

archangel_617b 03-31-2009 11:01 AM

Quote:

Originally Posted by nino_of_qubic (Post 3492625)
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

nino_of_qubic 03-31-2009 10:04 PM

Quote:

Originally Posted by archangel_617b (Post 3493822)
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

archangel_617b 03-31-2009 11:29 PM

Quote:

Originally Posted by nino_of_qubic (Post 3494429)
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


All times are GMT -5. The time now is 08:08 PM.