I have a website that I host (along with several others). It's a drupal site and I have several sites using the same drupal code base. Most of them work fine, but one of them is really slow. When I analyzed it in Firebug, it said that it spend 13-14 seconds waiting for a response from the server before it could even begin to load resources. I don't think it's a DNS problem. Does anyone have any ideas as to what I should check that would make this site and not any other on this server run slowly? Is this a problem with DNS? Is it a problem with Drupal? Is it a problem with httpd? I don't know. Server is RHEL5 Drupal version is 5.10 DNS server is Bind9 Apache version is 2.2.3 PHP version is 5.1.6 MySQL version is 5.0.22 Thanks in advance.
Thanks for answering me. I've checked the server load and it doesn't look abnormal. I even tried a reboot late last night (as crazy as that sounds) and that didn't seem to solve the problem. I know there are like 80,000 things that could cause this, and I'm about at the point where I think I should just line them up and knock them down one by one. Do you have any suggestions on where to start? Thanks.
Update. It's got to be something in the config, setup or database of this drupal site. Here's how I narrowed that down. Our DNS server handles several domains. One of which is ours and we put a lot of our client sites on subdomains before full release by doing client.ourdomain.com. So I setup that url in the DNS. I then directed it to our web server where I set up an apache entry sending it to the drupal install. I then used ln to create a symbolic link to the slow site. Using this I loaded the site by going to client.ourdomain.com and it behaved the same as before when it was just client.com. So the next step was to change the ln. I mentioned before that I have other sites running off this same codebase that are fine, so the only thing I changed was to make the link point to one of the other ones that I know is fine. I left all the server settings alone. Then I tried loading the OK site by going to client.ourdomain.com and it loaded fine. So the problem has got to be in the settings or database of that specific site. It can't be the server... right? Thanks again.
It could actually be quite a few things here. For example, depending on the amount of data you have in your database, certain lookups may take longer than those that would happen on a 'new' site. It could also be graphic image sizes, etc. To rule out MySQL, you might want to google for 'mysqltuner.pl'. Download this and run it on your server. It should let you know if there are optimizations you can make to MySQL that could help out. Also if you have a lot of plugins on your site, you may want to attempt disabling them one at a time and re-checking the site. Some Drupal plugins can get to be a bit nasty.