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
Re: upgrade 3.23 - 4.0.3 question
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
upgrade 3.23 - 4.0.3 question
Hi, It seems that the instructuons on http://www.mysql.com/doc/en/Upgrading-from-3.23.html are contradicting themselves, or I'm mistaken: *** first snap *** Ensure that you don't have any MySQL clients that uses shared libraries (like the perl Msql-Mysql-modules). If you have, you should recompile them as structures used in `libmysqlclient.so' have changed. * *** second snap *** MySQL 4.0 will work even if you don't do the above, but you will not be able to use the new security privileges that MySQL 4.0 and you may run into problems when upgrading later to MySQL 4.1 or newer. * *** third snap *** Old clients should work with a Version 4.0 server without any problems. * Structures in libmysqlclient having been changed seems to be a serious thing, so should or should not Msql-Mysql-modules be recompiled? 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? Regards Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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
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