No, switching to 4.0.2 didn't help either, and here is an additional clue which may help: all mysql threads on the 4.0.* are in the "sending data" state, while for the 3.23 the state is changing all the time to "writing to the net", "connecting" and others. It seems as though the 4.0 version has problems in communicating with DBI module which was left unchanged. So again we're returning to the questuin should DBI be reinstalled or no?
regards ---- Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Mon, 2 Sep 2002, Varshavchick Alexander wrote: > Date: Mon, 2 Sep 2002 11:02:54 +0400 (MSD) > From: Varshavchick Alexander <[EMAIL PROTECTED]> > To: Steven Roussey <[EMAIL PROTECTED]> > Cc: Mysql <[EMAIL PROTECTED]> > Subject: Re: upgrade 3.23 -> 4.0.3 question > > I'm using 3.23.49 and it behaves perfectly. Okay I'll try 4.0.2 and see > if it helps, thanks for the hint. > > ---- > Alexander Varshavchick, Metrocom Joint Stock Company > Phone: (812)118-3322, 118-3115(fax) > > On Fri, 30 Aug 2002, Steven Roussey wrote: > > > Date: Fri, 30 Aug 2002 10:49:28 -0700 > > From: Steven Roussey <[EMAIL PROTECTED]> > > To: Mysql <[EMAIL PROTECTED]> > > Cc: 'Varshavchick Alexander' <[EMAIL PROTECTED]> > > Subject: Re: upgrade 3.23 -> 4.0.3 question > > > > ------------- > > The real cause for the question lays in the problem which occured after > > I > > upgraded to 4.0.3 WITHOUT recompiling DBI module: the new mysql version > > worked without any visible errors, however it was unable to process more > > than about 30 queries per seconds, while the normal rate for this server > > is more than 100 queries/sec. How can it be so slow? Evidently something > > went wrong, but what could it be? > > ------------- > > > > Would you be willing to try using 4.0.2 instead of 4.0.3? If you do not > > have the problem with 4.0.2, then the issue lies in something in 4.0.3. > > At least I have a problem with 4.0.3 in that it works fine for a few > > queries, but when I let it go at a normal 3000 queries per second it > > choked up and died (much like 3.23.51 -- by the way, which 3.23.x are > > you using now?). > > > > Thanks! > > > > Sincerely, > > Steven Roussey > > http://Network54.com/?pp=e > > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
