Rick Hurst Web Developer in Bristol, UK


slow response from mysql database on another server

I set up a mysql database earlier and was getting a very slow response (about 4 seconds to connect) from a php script on another server. Both servers were windows (yeah I know, not my choice!). After a bit of googling I found the cause of this is DNS checking that occurs for incoming requests from seperate servers. The solution is to put skip-name-resolve into the mysqld section of my.ini (mysql config file)