Trouble-shooting a really slow website

[Vee]

Last year I made a drupal based website, which after a few months I had to abandon because it was taking up too much of my time, among other reasons. I want to go back to maintaining it now but first I need to find out why every page loads soooo slowly.

How slow? Don't laugh:



Yeah.

So, I'm wondering, are there a set of likely culprits that could be making my site slow to load? Things I can check, like disabling certain modules or something?

(I'm kind of thinking in terms of if your PC or browser was acting slow there are a set of things you can do, like run a virus scan, malware scan, and stuff like that to see if that fixes the problem)

Just basically, how do I find out what's slowing down my site so I can fix it?

Thanks.

By the way, there's this, if it helps:



I dunno how I fucked it up so bad

EDIT: And there's this:

Vee Reviewed by Vee on 6th Feb 2012. Trouble-shooting a really slow website Last year I made a drupal based website, which after a few months I had to abandon because it was taking up too much of my time, among other reasons. I want to go back to maintaining it now but first I need to find out why every page loads soooo slowly. How slow? Don't laugh: http://i.lulzimg.com/09b49908a2.jpg Yeah. :facepalm: So, I'm wondering, are there a set of likely culprits that could be making my site slow to load? Things I can check, like disabling certain modules or Rating: 5

[Smith]

Sorry for going offtopic but which website is that ^?

With performance screens etc.

Thanks!

[Vee]

pingdom:

http://tools.pingdom.com/fpt/

[outbreak]

Well, if you gave us a link to your site we could tell you a lot more.

Edit:
Sorry my bad... I missed the Durpal part

[Hotaru]

Mostly because you serve static files (js, css, images) from apache or iis, which is not good at all. You should setup a subdomain with nginx, and serve static files from that subdomain. If you have only one vps, run nginx on port 80, apache on another port. Then config nginx listen to your domain, and setup reverse proxy to your apache port. Also, consider using cache.

[Vee]

Mostly because you serve static files (js, css, images) from apache or iis, which is not good at all. You should setup a subdomain with nginx, and serve static files from that subdomain. If you have only one vps, run nginx on port 80, apache on another port. Then config nginx listen to your domain, and setup reverse proxy to your apache port. Also, consider using cache.

Sorry, that's like a foreign language to me

[Loonycgb2]

If your site is loading slow.. Especially it being a high mysql usage app it has little to do with static files.

It mainly has to do with how bad your query load is... Some drupal sites are so full of bad coding it makes the mysql hang making load times go up to 10-20 seconds...

If it is just slow on initial load then you might have a caching problem.. Useing gzip will help but is very cpu intensive

[Vee]

I don't think it's just initial load. When I'm browsing it myself it can take ages to load a particular page even if I've just loaded it a few second before. Then again, very occasioanlly a page that took ages to load before will load quickly. Generally though, every page is very slow no matter if I've loaded it before.

What should I do? Start again sans-drupal?

EDIT: is it possible to switch from drupal to wordpress and keep your database? Cos I have a pile of user accounts and stuff.

[Loonycgb2]

Well either if you have a vps or dedi have someone tune your servers for you..

If your on a shared.. consider your host might not be that good or else they could have told you the reason them selfs