Hello!
I'm working with a few people on a PHP/MySQL messageboard script that has just been moved to a different webhost from the one where it was developed. The board generates an average of about 30 gigabytes of traffic per month. On the development webhost, the board ran like lightning. On the new webhost, the board is tediously slow, sometimes taking upwards of 30 seconds to actually load the index page.

A few details... both webhosts are using PHP 4.03pl1 and MySQL version 3.23 (stable). PHP is compiled into Apache on both hosts. Both hosts are running Linux. Pings to both webhosts are well under 100ms.

Not sure if this info will help, but here is the phpinfo() output for both hosts:

Slow host:
http://www.digiphobia.com/testphp.php

Fast host:
http://64.225.100.62/phpinfo.php

I haven't seen the php.ini file from either host. Both hosts have the site files and MySQL running on the same server.

Given this information, which granted probably isn't nearly enough for troubleshooting purposes, what should I be asking of the slow webhost? Could it be the way the compiled PHP's MySQL support into Apache or would it most likely be something with their MySQL installation?

Just looking for a push in the right direction. Thanks in advance!

    Its far more likley to do with their connection to the internet. For most small sites its impossible to tell the difference, but for your site you'll need a good connections. They coule have anything between 256k to 200mb (or more)

    John

      When we had trouble with the PHP/MySQL board, we reverted to our Perl CGI-based board and the index page usually loads within 3 seconds, so we're pretty sure it's not an internet connection issue.

      When we put some fake breakpoints in the script (just lines to print out before the database queries start and after they end), the first line shows up right away... then there's a huge delay... then the entire index page shows up all at once.

      We're 99.99% sure it has something to do with either their MySQL setup or their PHP setup, but we're not sure how to approach the troubleshooting.

      The MySQL database is on the same server as the board script, so there's no applicable latency between the web server and the MySQL server.

      Thanks for your response!

      • Dan Gilbert

        Is it possibly a DNS issue? Whatever you use in your connect commands might be having a hard time finding the server. (even tho the server it's looking for is itself!).

          Write a Reply...