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 single thread, hence can never use more than one core. So if your workload is dominated by 1 long-running query after another, it may seem like it's using only one core. Periodically check the output of "mysqladmin status"... if the thread counter is > 1, you're using multiple cores... assuming, of course, that your OS actually *knows* about them (ie: you're running an SMP-aware OS kernel). Jake On Mon, Dec 8, 2008 at 4:52 AM, Kunal Jain <[EMAIL PROTECTED]> wrote: > 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. > > -- > Kunal Jain, burrp! > http://burrp.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
