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 recently switched to AYK Solutions from Softlayer for my dedicated server requirements. I received a much better specification server at significantly reduced cost from what Softlayer could offer me, with many of the previously 'extra' features at Softlayer included in the base price offered by AYK. The support was second to none, and they were extremely helpful in transferring all of my old server accounts over for no additional fee whatsoever.
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!