How to set mysql CPU affinity?
Good evening!
I have 5.5.38-0+wheezy1-log installed on Debian with nginx+apache and game server. Sometimes MySQL processes long queries which cause high CPU load and lags at the game server (unstable FPS problem). My idea is to put game server on the separate core #0 (done with taskset command), and all other processes to other cores #1 - #3.
I already set worker_cpu_affinity for nginx, but still I didn't find any solution for mysql and apache. I use MyISAM, so innodb_*** parameters are useful for me.
Is it possible to set cores which mysql server will use?
Maybe I need some custom modification to /etc/init.d/mysql, using taskset, to alow it work even after system restart. Please help me.
Subject
Views
Written By
Posted
How to set mysql CPU affinity?
5708
September 21, 2014 01:33PM
2457
September 22, 2014 03:25PM
2315
September 23, 2014 01:30AM
2005
September 23, 2014 11:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.