Are there any gurus out there that can help with optimizing queries /
mysql database, little freelance work? Maybe if I can get the
processing time down, this won't be as much of an issue.
Travis
David Brodbeck wrote:
>
>>-----Original Message-----
>>From: Travis Reeder [mailto:travis@stripped]
>
>
>>Is there a way to give mysql a lower priority?
>
>
> If you're on a UNIXish operating system, you could try running it with the
> 'nice' command. 'nice' lets you set the priority of the process you launch
> with it.
>
> Note that this only helps if it really is a CPU-bound process. It can still
> slow down the rest of the system if it's causing a lot of swapping or disk
> activity.
>