MySQL processor usage on a Xeon on Linux

Question

I run a LAMP server - Ubuntu 12.10 on a Intel Xeon 4 core proc.

I notice that mysqld only uses one core leaving the other 3 idle.

The server gets some pretty high loads at times and during these brief periods of high loads everything drags and only one core is utilized.

How can I configure MySQL to use all 4 cores and distribute its workload better?

Furthermore, I got a dual proc board in anticipation of this but omitted the second proc for now, so this should be addressed for this future upgrade.

Community · Accepted Answer · 2017-04-13 12:42:36Z

1

Have you looked at this thread?

Setting innodb_thread_concurrency to 0?

RolandoMySQLDBA said:

Once you set innodb_thread_concurrency to 0, you can set innodb_read_io_threads and innodb_write_io_threads (both since MySQL 5.1.38) to the maximum value of 64. This should engage more cores.

edited Apr 13, 2017 at 12:42

CommunityBot

11 silver badge

answered Mar 6, 2013 at 2:18

Freddie Fabregas

1,2031 gold badge8 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL processor usage on a Xeon on Linux

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related