>> 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
> I assume you've done the slow-query-log review thing... making sure all your
> queries are fast, yes?
Yes, you're right. After I did the myisamchk, the box has been more or
less stable with loads from 10 to 15. Still seems a lot ot me. I've
checked slow-query-log and only seemed to have one
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
1:22 AM
Subject: Re: AW: MySQL is hogging my box
> There are some others with a similar problem(including me). The question
> still remain,
> if it is all caused by the same bug(?).
> What table-types do you use? (MyISAM,Merge,BDB,...)
MyISAM
> How many entries are in the tables
(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
]
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
> There are some others with a similar problem(including me). The question
> still remain,
> if it is all caused by the same bug(?).
> What table-types do you use? (MyISAM,Merge,BDB,...)
MyISAM
> How many entries are in the tables?
Up to 145000 in some of the tables. But its not the usual
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
There are some others with a similar problem(including me). The question
still remain,
if it is all caused by the same bug(?).
What table-types do you use? (MyISAM,Merge,BDB,...)
How many entries are in the tables?
How many queries/second?
Do the queries use indices?
> Hi all, this is my first q
Hi all, this is my first question on this list and I hope that you can
help me. I've got one dedicated box for MySQL and it's going downhill just
by starting the DB. The box is a dual PIII 800Mhz, 1 Ghz RAM, Linux RedHat
6.2 w/ kernel 2.4.6SMP, SCSI Drives and plugged to a 100Mb internal
networ
10 matches
Mail list logo
