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

mysql eating up processor

2003-10-16 Thread Travis Reeder
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. Travis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe