Per some recommendations
on the mysql site about optimizing for a dual processor system, I'm trying to set the nice value of the mysqld_safe process. Since this box is used only for MySQL, I'm trying to set the nice value to -20, as it's supposed to give a fairly hefty performance increase. However, I'm having some issues trying to get the value to stick. I can run that command from a terminal window just fine, and it sets the value as it should. However, as soon as I close the window or session, the value resets to 0 again.
The exact wording that they used was this:
This can be done by adding a renice -20 $$ command to mysqld_safe.
The mysqld_safe is a shell script, but they give no advice on where to add this command. I put it in at the start and at the end of the script, but it didn't appear to make any difference.
So, I guess I'm hoping there's a way to set the process priority in such a way that it will stick. If anyone has any suggestions, I'd appreciate them.