I am seeing my tools very slow connecting to the sql servers, such as taking 33 or 79 seconds just for figuring out the right server and connecting to it, and even failing with «Can't connect to MySQL server on 'sql-s4-rr.toolserver.org'» (not only on this server)
Are sql servers overloaded? Is it a problem with willow? Should we give a kick to the tcp stack? This anomaly is also visible from the command line, varying from immediate connection to slow one: $ time mysql -h sql-s4-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m0.098s user 0m0.003s sys 0m0.009s # Shouldn't it always so quick? $ time mysql -h sql-s4-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m4.803s user 0m0.003s sys 0m0.009s $ time mysql -h sql-s4-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m1.619s user 0m0.003s sys 0m0.009s $ time mysql -h sql-s4-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m4.222s user 0m0.003s sys 0m0.009s $ time mysql -h sql-s4-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m15.434s user 0m0.003s sys 0m0.008s $ time mysql -h sql-s3-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m13.463s user 0m0.003s sys 0m0.009s $ time mysql -h sql-s3-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m2.356s user 0m0.003s sys 0m0.009s $ time mysql -h sql-s3-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m1.850s user 0m0.003s sys 0m0.008s $ time mysql -h sql-s3-rr.toolserver.org -e 'SELECT VERSION()' +-----------+ | VERSION() | +-----------+ | 5.1.59 | +-----------+ real 0m24.724s user 0m0.003s sys 0m0.008s _______________________________________________ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
