Re: AW: MySQL is hogging my box

2001-09-19 Thread lcalero
> 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

Re: AW: MySQL is hogging my box

2001-09-18 Thread Dana Powers
I assume you've done the slow-query-log review thing... making sure all your queries are fast, yes? dpk - Original Message - From: <[EMAIL PROTECTED]> To: "Stefan Pinkert" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 18, 2001 1

Re: AW: MySQL is hogging my box

2001-09-18 Thread lcalero
> 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

AW: MySQL is hogging my box

2001-09-18 Thread Stefan Pinkert
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