Restricting Processes
 

Is there a way to restrict processes for applications. In this case, mysql seems to be taking alot of the system resources in chunks (rather than a continous stream).

Is this possible?

"renice" will let you change the priority of a process over the processor time.
I don't really remember the syntax, take a look to "man renice" or "man nice"