By sumoanand on

hi ,

My drupal based website was working fine on sunday evening but on next day i found that its response time decreased from 5-6 sec to 40-45 sec. :(

I called up my hosting provider, they tried to figureout the problem but in vein & in the end they changed the server. But still the response time is around 20-25sec.

Can someone plz let me know, what may be the possible cause of this problem?

Thanks,
Sumeet

⋅ Categories: Drupal 4.7.x

Comments

mwu’s picture

mwu commented

do you mean increased?

I see. Maybe you mean deteriorated.

nevets’s picture

nevets commented

A link to your site would be useful if you want others to look at your question. You might also want to try the devel module which has tools for showing you where the time loading a page is spent

sumoanand’s picture

sumoanand commented

website is ifood.tv

Regards,
Sumeet Anand

yelvington’s picture

yelvington commented

Look at your error logs and see if you are being hit by many requests for nonexistent files. You may need to disable Drupal's role as 404 handler.

sumoanand’s picture

sumoanand commented

How to disable the 404 support?
(by setting 'Default 404 (not found) page:' field as BLANK or some other way??)

firstov’s picture

firstov commented

I think the easiest way would be to create a static html page error404.html in your folder and then edit .htaccess file to point this page as an error page using ErrorDocument directive:
in your .htaccess add this:
ErrorDocument 404 /error404.html

www.firstov.com

nevets’s picture

nevets commented

While your front page loads slow, the other ones I tried are even slower. I would try the devel module and enable the option to time page loads, it will help you determine where the time is going.

One element which may be import, it took a while for the browser to even find "ifood.tv" so the DNS look may be slow and part of the problem.

master2006’s picture

master2006 commented

I work with Sumeet on this. Our site www.ifood.tv is hosted at Dreamhost. The interesting part is that we didn't make any changes and all of a sudden the site started performing very slow. Almost every thing on the site is slow. Our host is telling usthat everything is good on there side. We have tried many things with no improvements. Your help is greatly apprecaited.

Regards

Robardi56’s picture

Robardi56 commented

Dreamhost ? If you are not on a dedicated server (are you ?), this kind of slowdown is something you should learn to live with..... I have hobby sites hosted on Dreamhost, and they are from time to time affected by slow down storms..... sometime they say that they are under attack, sometime it is a customer eating to much cpu.... and sometime the server is just overloaded.

Brakkar

master2006’s picture

master2006 commented

Dreamhost customer service responded and they moved us to a different server, but the problem is still there. I wonder is there any good host? Google search leads to a barrage of marketing message, it is hard to find something good. I want to copy our site to a new host at least to verify that the problem is host related. We have already spent lots of time trying to debug. Any suggestions?

Thanks

sumoanand’s picture

sumoanand commented

I have installed the DEVEL module, following is my observation:

Main problem seems to be with the INSERT statement, it is taking around 7875.42ms where as other SELECT statements r taking 5-10ms.

Time: 7875.42ms

where: statistics_exit

INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('', 'front_page', 'http://ifood.tv/?q=admin/settings/devel', '81.1.103.128', 1, 'kjcl7fsrgkdv6ps71akh4u6m17', 786, 1160523443)

So is this the problem is due to some module or the hosting provider problem??

sumoanand’s picture

sumoanand commented

On accessing Nodes got following time response:

9647.57ms to update cache table
2677.31ms to update node_counter table
2402.38ms to update cache table
1210.88ms to update cache table
880.47ms to update accesslog table
642.66ms to update cache table

firstov’s picture

firstov commented

Try running MySQL Admin (if dreamhost has it), then select your database and see if there are tables with lots of overhead, then run "optimize" for those tables.
Another thing to try out (not on the production site) is to use file caching module from http://drupal.org/project/fastpath_fscache. This is still in beta, but for hosts with slow databases this will help a lot.

www.firstov.com

xjessie007’s picture

xjessie007 commented

Do you mind if I ask how you get these stats?

I use the following code to measure how quickly page loads, but yours looks like more sophisticated :), how do you get these numbers?

$startTime = array_sum(explode(" ",microtime()));
$stopTime = array_sum(explode(" ",microtime()));

---------
www.Maxi-Pedia.com

xjessie007’s picture

xjessie007 commented

Hi,

I have exactly the same problem, perhaps just a little difference in timing. When I uploaded my web (www.maxi-pedia.com) to the webhosting server, everything was super slow. It would take 20 secs to get a page, I would always get the "Waiting for http://....." in the browser status bar. I sent email to the provider, and they said everything is ok on their end. They also said they checked other websites on the same server, and those worked fine. Then I went to my website later, and everything seemed to work relatively fine, no hickups anymore. It looked to me like the slowness suddenly went away. I turned on Drupal Throttle ON, but I am not sure if that could have solved the problem. I am puzzled by this too.

Anyway, I would also like to keep an eye on this, but I am still new to Drupal. You mentioned the devel module. Can you, pls, be more specific which one it is, and how to use it, etc?

Btw, I wonder if the slowness could be related to third-party inputs. For example, I have Google Adsense at the website. If there was a slow connection to Google, would that affect how quickly my pages show up too? Anyone knows?

attiks’s picture

attiks commented

Most shared hostings limit the number of connections to the database, or use one database server for multiple webservers. So if another site is generating a lot of database traffic it will slow down all other sites using the database. Same goes for regular surfing, if there's a really popular site on the same webserver as you are, changes are it will slow down all the others.

External references can slow down your site (like google Adsense / Analytics), but worst case I saw was like an extra second or so.

@xjessie007: The devel module can be found at http://drupal.org/project/devel

@master2006: Try upgrading / moving hosts, at least try to get a (virtual) dedicated machine. BTW speed looks good right now :p

Attiks - graphic design and web applications

Attiks - Print and web design

xjessie007’s picture

xjessie007 commented

Hi, thanks much for your explanation. Makes sense. I just opened an account with my hosting provider, so I am trying to find some solution with them for now. Thanks for the link to the devel module. A very nice one. I have a question if you do not mind.

I included a script to the web to measure how quickly the page loads, and I can see my pages load within 0.001 to 0.003 seconds. That seems pretty fast to me. I even hesitate to believe my pages really load that fast. I included the following script into page.tpl.php. Do I have my script right, and is it even possible for my web pages to load that fast?

$startTime = array_sum(explode(" ",microtime()));
 ...page code...
$stopTime = array_sum(explode(" ",microtime()));
echo round($stopTime-$startTime,6);

If my code is right, and my web pages really load that fast, I would have a case that the problem must be with the hosting server not being able to serve requests for my web quickly enough, I guess.

Another thing, I have this web physically hosted in the Czech Republic because of their great prices ($1.9/month). It is true that when viewing my web from the US, the electrons have to travel 6000 miles one way and then 6000 miles back, but I did not think that would really be a problem. There are many Czech websites that go fast. Do you think the fact that my web is hosted over seas could play any significant role in regards to the "Waiting for...." problem? Tx.

www.Maxi-Pedia.com

attiks’s picture

attiks commented

I think your timing is in the wrong place (0.003 is really fast), better to use the timing that's included in the devel module since it will start recording time from the start. There's a lot going on before page.tpl.php gets loaded.

Distance shouldn't be that much of a problem but the more hops in between you and the webserver the bigger the change (in theory) for congestions/delays.

PS: If you use FF, have a look at YSlow (http://developer.yahoo.com/yslow/)

Attiks - graphic design and web applications

Attiks - Print and web design

CBIL360’s picture

CBIL360 commented

It seems server response time for your website is more, it need to be checked. You can use some tools like pingdom for getting detailed report!

You also have too many images at home page I think with help of image optimizer you can also reduce size.