Re: mysqld refusing connections while getting sloooow

2002-06-12 Thread Gelu Gogancea
--- Original Message - From: "Stefan Hinz" <[EMAIL PROTECTED]> To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Nilesh Shah" <[EMAIL PROTECTED]>; "Jared Richardson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002

Re: mysqld refusing connections while getting sloooow

2002-06-11 Thread Stefan Hinz
[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 9:16 PM Subject: Re: mysqld refusing connections while getting slw > Hi, > My opinion is: > This is a specific behaviour for tables which are not properly indexed. > > Regards, > Gelu > __

Re: mysqld refusing connections while getting sloooow

2002-06-11 Thread Stefan Hinz
Hinz" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 8:36 PM Subject: RE: mysqld refusing connections while getting slw I think increasing memory and giving more memory to MySQL would help. Nilesh -Original Message- From: Jared Richardson [mail

Re: mysqld refusing connections while getting sloooow

2002-06-11 Thread Gelu Gogancea
] - Original Message - From: "Nilesh Shah" <[EMAIL PROTECTED]> To: "Jared Richardson" <[EMAIL PROTECTED]>; "Stefan Hinz" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 9:36 PM Subject: RE: mysqld refusing connections while

RE: mysqld refusing connections while getting sloooow

2002-06-11 Thread Nilesh Shah
I think increasing memory and giving more memory to MySQL would help. Nilesh -Original Message- From: Jared Richardson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:48 PM To: Stefan Hinz; [EMAIL PROTECTED] Subject: Re: mysqld refusing connections while getting slw

Re: mysqld refusing connections while getting sloooow

2002-06-11 Thread Jared Richardson
We've seen very similar behavior when there are very long SQL queries being run that are disk intensive.. generally speaking, something is having to traverse the table (or a temp table) line by line. If he has any logging capability, see long each SQL query is taking to return to his app then cle