Re: Re: MySQL is hogging my box

2001-09-19 Thread Stefan Pinkert
>> There are some others with a similar problem(including me). > >Hi guys. I'd be really interested in knowing things like how many requests, and of what type, are being made of >your database(s). If you're making a couple of dozen SELECTs per day, then I'd say that you have a problem, but >if you

Re: MySQL is hogging my box

2001-09-18 Thread Michael McConnell
uot; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 18, 2001 10:58 AM Subject: Re: MySQL is hogging my box > (to answer a couple of posts at once): > > Our machine was seeing less than 20 connects / sec. The problems > continued after we broke largeish

Re: MySQL is hogging my box

2001-09-18 Thread djinn
(to answer a couple of posts at once): Our machine was seeing less than 20 connects / sec. The problems continued after we broke largeish (although only about 350,000 records, indexed) tables into smaller ones and verified/optimized all code that makes mysql queries. We have a good mix of selec

RE: MySQL is hogging my box

2001-09-18 Thread Dan Rowe
] Subject: Re: MySQL is hogging my box From: Stefan Pinkert <[EMAIL PROTECTED]> > There are some others with a similar problem(including me). Hi guys. I'd be really interested in knowing things like how many requests, and of what type, are being made of your database(s). If y

Re: MySQL is hogging my box

2001-09-18 Thread Rodney Broom
From: Stefan Pinkert <[EMAIL PROTECTED]> > There are some others with a similar problem(including me). Hi guys. I'd be really interested in knowing things like how many requests, and of what type, are being made of your database(s). If you're making a couple of dozen SELECTs per day, then I'd