By fox12345 on

Hi,

Hope someone can help...

1. Over one million GET requests each day that is killing the server.
2. When Googlebot comes to index the whole thing crashes.
3. 25k visitors a day and growing
4. Top requests:
8274 /misc/progress.js?v=7.34
8275 /misc/ajax.js?v=7.34
8317 /sites/all/modules/jquery_update/replace/ui/external/jquery.cookie.js?v=67fb34f6a866c40d0570
8333 /sites/all/modules/jquery_update/replace/misc/jquery.form.js?v=2.67
9798 /sites/all/modules/jquery_update/replace/jquery/jquery.js?v=1.5.2

As you will see most of the requests are ajax and jquery and my menu is built in jquery.

Can anyone provide some advice on how to optimise these queries or do you think I need to move mysql onto it's own server as I see the traffic is only going to grow.

Thanks so much for your help.

⋅ Categories: Drupal 7.x

Comments

iaha’s picture

iaha commented

It looks like you haven't turned on caching and JS/CSS aggregation. But more importantly, I wonder if you might have page caching disabled. Check out Configuration / Performance, and turn on caching and aggregation. If it was off before, you should notice an improvement after turning it on. If caching was already on, you may have to extend the minimum cache times and/or configure caching on some views as well.

I suppose there may be custom code on the site as well. Aside from the "no caching" problem, the most common performance issue I see on Drupal sites is caused by cowboy code (often in themes) that isn't using the Drupal framework. If you have a lot of cowboy code, it's going to need to be fixed eventually, but maybe use XHProf or something to help identify and address the most problematic areas in the short term.