Re: mysql eating up processor

2003-10-16 Thread Travis Reeder
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:[EMAIL PROTECTED]

Re: mysql eating up processor

2003-10-16 Thread Travis Reeder
It's running on Redhat 9. Travis Jeremy Zawodny wrote: On Thu, Oct 16, 2003 at 02:45:26PM -0600, Travis Reeder wrote: Is there a way to give mysql a lower priority? I have an app that is constantly using the database and it is pinning the processor constantly which makes it hard for other ap

Re: mysql eating up processor

2003-10-16 Thread Jeremy Zawodny
On Thu, Oct 16, 2003 at 02:45:26PM -0600, Travis Reeder wrote: > Is there a way to give mysql a lower priority? I have an app that is > constantly using the database and it is pinning the processor constantly > which makes it hard for other applications to run. What OS are you using? -- Jeremy

RE: mysql eating up processor

2003-10-16 Thread David Brodbeck
> -Original Message- > From: Travis Reeder [mailto:[EMAIL PROTECTED] > 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