来自localhost的远程MySQL连接Codeigniter =非常慢

Question

I am using Codeigniter & LAMP stack (without the MySQL) on my localhost to connect to a remote MySQL database on my server. This configuration is for development purposes only.

Problem: It takes up to a minute for the entire page to load! Is there any way to make this connection faster?

Sometimes its so slow i even get the error:

A Database Error Occurred

Unable to select the specified database: x

Filename: /Applications/MAMP/htdocs/x/third_party/MX/Loader.php

Line Number: 96

Answer 1

Unless your app is very hard on the DB, it is very likely that reverse DNS resolution is the cause. Disable it on the remote server by adding skip-name-resolve to your my.cnf.

Also, note that even for simple queries, the roundtrip "across the world" may be 200 ms or even more, so it only takes 300 queries to spend a minute on networking, regardless of the complexity or amounts of data.