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.
After getting a dedicated server from AYK for almost 2 years, I couldn't be more happy. The prices are very reasonable, I haven't experienced a moment of downtime, the support is excellent and truly 24/7. You have a critical issue at 2am? You will have it sorted out in less than 15 minutes. If you are looking for honest, reliable and affordable hosting provider, look no further!
Outstanding Customer Service Everytime I have emailed AYKsolutions I have gotten an outstanding response time from the technical support team. Not only that, they are very friendly and very easy to work with. When I initially setup my account I had a small problem and had to delete everything and start over. This was not a problem for AYK and they were able to get me up and running in no time at all