Re: Multiple Cores.

2008-12-08 Thread Jake Maul
MySQL processes each request in a separate thread... hence, it is *always* multi-core capable. Check the thread_concurrency setting in my.cnf. Also, although not exactly related, check the size of thread_cache. Are you by chance running 1 long-running query at a time? A single query runs in a sing

Re: Multiple Cores.

2008-12-08 Thread walter harms
Kunal Jain schrieb: > How we can configure Mysql in such a way so that i start using all the cores > of CPU. I Have a QuadCore server but somehow mysql use only single core > whose usage percentage goes upto 99% while other three cores remains idle. > > Any Idea or Multiple Core/CPU is wastage.