List:General Discussion« Previous MessageNext Message »
From:Frank Febbraro Date:December 7 2004 5:15pm
Subject:MySQL 4.1.7 Network slowdown
View as plain text  
We just installed MySQL 4.1.7 (we were previously using 4.0.22)

Our applications have now become extremely slow. When executing
queries directly on the database server, our response times are "228
rows in set (0.00 sec)"  When we execute them from our development
servers (via mysql query browser, or using Connector/J) we get 228
rows in 5172 msec.

I do not really know what to do to try to determine the cause of the
slowdown. Using trace route there is only one hop directly to the DB
server and large files transfer lightning quick so I do not think it
is a network problem, but rather a MySQL connection problem.

Can someone please provide a pointer or two to try to determine what
is going on? 4.0.x was significantly faster, but I now need
subqueries.

Thanks in advance,
Frank
Thread
MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
  • Re: MySQL 4.1.7 Network slowdownRonan Lucio7 Dec
    • Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
  • Re: MySQL 4.1.7 Network slowdownRonan Lucio7 Dec
    • Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
      • Re: MySQL 4.1.7 Network slowdownGreg Whalin7 Dec
        • Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
          • Re: MySQL 4.1.7 Network slowdownMark Matthews7 Dec
            • Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
              • Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
          • Re: MySQL 4.1.7 Network slowdownGreg Whalin7 Dec
  • Re: MySQL 4.1.7 Network slowdownRonan Lucio7 Dec
Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
  • Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
    • RE: MySQL 4.1.7 Network slowdownDonny Simonton7 Dec
      • Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
        • RE: MySQL 4.1.7 Network slowdownDonny Simonton7 Dec
          • Re: MySQL 4.1.7 Network slowdownFrank Febbraro7 Dec
            • RE: MySQL 4.1.7 Network slowdownDonny Simonton7 Dec
              • Re: MySQL 4.1.7 Network slowdownKevin A. Burton8 Dec