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.
AYKsolutions - best solution for small/high business I have several plans with them and i can sleep well because their team watch over my servers. I started with a small shared account and now, after two years i have multiple dedicated boxes. I like the way they treat their customers, even if they have a small or a big plan. Their tehnical support is the best i ever meet ( worked with many hosting pro viders ). In one word: If you need cheap and no headache for your internet bussiness, AYKsolutions it's your best choice
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 have a two small shared hosting packages and the price I pay I don't expect to receive very good support. I accept with any shared hosting uptime cannot be guaranteed neither can it be 100% and anyone who suggests otherwise is living a dream. However on the occasions I have opened a ticket they have been answered and investigated promptly. I have been with ayksolutions.com since Jun/18/2008 oh wow where has the time gone!