I have developed a site on the Linux server (my test host server) but when I take the site to a live server , Which is IIS, Windows 2003 ... My site is very slow It takes about 20 seconds to load a page. My code is in PHP and I am using Wordpress. Generic HTML, PHP pages are running fast, but when it connects to MySQL, it only connects 4 to 5 seconds.
Any ideas?
Description: IIS Windows 2003 PHP MySQL Wordpress (I used the ODBC to connect to the mssql database for some pages)
Let me know if I miss any details It is often a DNS problem with reverse lookup.
When you join MySQL, MySQL will attempt to determine the host's IP name that is associated with it. If MySQL can not access any DNS server for this, then there is a 5s timeout. Try starting with
MySQL
[mysqld] skip-name-resolve in the my.ini file And see if the problem goes away. Note that by setting this option it shows that instead of using the domain names you create user grants ("Allow all USER@10.1.1.1 ...") only with IP numbers.
If that option fixes the problem, get your DNS in order and you can remove the option.
Comments
Post a Comment