{"id":5088,"date":"2015-08-11T20:46:34","date_gmt":"2015-08-11T12:46:34","guid":{"rendered":"http:\/\/rmohan.com\/?p=5088"},"modified":"2015-08-11T20:46:34","modified_gmt":"2015-08-11T12:46:34","slug":"mysql-slow-remote-connection-causes-and-solutions","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=5088","title":{"rendered":"MySQL slow remote connection causes and solutions"},"content":{"rendered":"<p style=\"font: 14px\/28px ??, 'Arial Narrow', arial, serif; margin: 0px; padding: 0px; height: auto; color: #555555; text-transform: none; text-indent: 0px; letter-spacing: normal; overflow: hidden; clear: both; word-spacing: 0px; white-space: normal; widows: 1; font-size-adjust: none; font-stretch: normal; background-color: #ffffff; -webkit-text-stroke-width: 0px;\">Because the network is deployed MySQL server, there is no load, when the speed local connections are normal, but it is especially slow when connected via a network, the last inspection found that a DNS resolution problem<\/p>\n<p style=\"font: 14px\/28px ??, 'Arial Narrow', arial, serif; margin: 0px; padding: 0px; height: auto; color: #555555; text-transform: none; text-indent: 0px; letter-spacing: normal; overflow: hidden; clear: both; word-spacing: 0px; white-space: normal; widows: 1; font-size-adjust: none; font-stretch: normal; background-color: #ffffff; -webkit-text-stroke-width: 0px;\">In the MySQL configuration file \/etc\/my.cnf in the [mysqld] added<\/p>\n<p style=\"font: 14px\/28px ??, 'Arial Narrow', arial, serif; margin: 0px; padding: 0px; height: auto; color: #555555; text-transform: none; text-indent: 0px; letter-spacing: normal; overflow: hidden; clear: both; word-spacing: 0px; white-space: normal; widows: 1; font-size-adjust: none; font-stretch: normal; background-color: #ffffff; -webkit-text-stroke-width: 0px;\">skip-name-resolve<\/p>\n<p style=\"font: 14px\/28px ??, 'Arial Narrow', arial, serif; margin: 0px; padding: 0px; height: auto; color: #555555; text-transform: none; text-indent: 0px; letter-spacing: normal; overflow: hidden; clear: both; word-spacing: 0px; white-space: normal; widows: 1; font-size-adjust: none; font-stretch: normal; background-color: #ffffff; -webkit-text-stroke-width: 0px;\">Reboot, test the normal speed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p style=\"font: 14px\/28px ??, 'Arial Narrow', arial, serif; margin: 0px; padding: 0px; height: auto; color: #555555; text-transform: none; text-indent: 0px; letter-spacing: normal; overflow: hidden; clear: both; word-spacing: 0px; white-space: normal; widows: 1; font-size-adjust: none; font-stretch: normal; background-color: #ffffff; -webkit-text-stroke-width: 0px;\">Because the network is deployed MySQL server, there is no load, when the speed local connections [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5088"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5088"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5088\/revisions"}],"predecessor-version":[{"id":5090,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5088\/revisions\/5090"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}