Allows you to search a variety of questions and answers
If you want to permanently renice Mysql, you need to first find where the mysqld_safe or safe_mysqld file is. Typically it's located within the /usr/bin directory.
Then, with your favorite editor, add or change (if the line is already present) the following:
niceness=value (between -20 and 20, with -20 being the most resource needful and 20 being the least)
Then just restart Mysql.
I have been with ayksolutions for around 5 years and have been thoroughly impressed with them. All support tickets are answered within minutes, regardless of the time of day. Prices are very reasonable, especially considering the support and services they provide. They are constantly doing crazy deals for servers as well. If you're looking for someone good and reliable to host with, from shared hosting to dedicated servers, I easily recommend ayksolutions.
I've been a client of AYK Solutions for about six months now. They have provided the best overall experience I have had in over 10 years. I've tried iWeb, SingleHop, and a few others supposed to be the so-called best. Specifically, you are dealing with personal, professionals with AYK Solutions, and they are willing to help when all others want to charge you $** for this and $**/hr for that. I'm happy, and have no plans of going anywhere else; ever.