Website generates slooow

wordpress

#1

My website is taking between 15 to 30 seconds to generate on the server, measured wby the PageCache component.

I use latest Joomla 1.0.x and Virtuemart 1.0.x , the only modules being used are the Virtuemart Shop Module and the Virtuemart Random Product module, tried to disable those but still takes a lot to generate.

Only other component working on the site is sh404sef, also tried to disable it but no significative difference.

I tried the Pagecache 2.0 component but didn’t got any improvement -anyway, the generation time function is a really nice one-. I have looked for problems on the CSS, W3 validator errors, etc… but still being ubberslow and just can’t think what else to look at. Queries for the frontpage are about 130.

We have about 1000 visits daily, so it can’t hardly be an issue of too much users.

The web will load faster or slower without any modification, depends on the moment it will load slow, slower, or simply won’t load, without modifiying anything.

I get a lot of Premature end of script headers: php5.cgi

That’s what makes me think it is not a coding issue but a server issue.

My server is wrangler and my MySQL server is stuartlittle:kjellman

I will take any suggestion about where to look to find the error and how to fix it.

Oh, by the way the site is www.dragons-spirit.com


#2

My sites are incredibly slow today. Anything that involves database access - Joomla, Drupal, Wordpress etc. But my servers are different to yours, mine are fanta (web) and comet (MySQL). I’m currently building a new site using Drupal and it’s taking me a very long time.


#3

I have been told that to see if sh404sef or any other sef component is affecting my performance, I must disable it for some hours before I can really see any benefit of disabling it, is that true?


#4

I shouldn’t think so. Flush any caching you have going on.

You could do a one-click install in a temporary subdomain and check a vanilla copy.


#5

My sites stopped responding altogether for a short while, but now are back and much faster. Is yours any better now?


#6

No, but this is not temporary issue, I have been having this problem for a while.


#7

Apart of my problems, seems someone is abusing the server:

top - 10:57:49 up 2 days, 18:24, 7 users, load average: 141.23, 125.47, 120.4
Tasks: 3 total, 2 running, 1 sleeping, 0 stopped, 0 zombie
Cpu(s): 72.4% user, 27.6% system, 0.0% nice, 0.0% idle
Mem: 4075060k total, 3958664k used, 116396k free, 8932k buffers
Swap: 6313512k total, 159164k used, 6154348k free, 881308k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26420 dragons_ 15 0 18340 17m 5260 R 0.7 0.4 0:00.68 php5.cgi
15021 dragons_ 9 0 1544 1540 1148 S 0.0 0.0 0:00.05 bash
18649 dragons_ 9 0 908 908 752 R 0.0 0.0 0:00.23 top


#8

Send that to Support. Nag them enough and they’ll either move you to a better server, or cap the person loading the server.

-Scott


#9

Already sent, still no reply, but probably server rebooted as now load averages are about 12 or so, and my site is generating in 3 to 6 seconds. Anyway, I still feel like I can improve my configuration and code a little to get it even faster. Any sugerence is welcome :wink:


#10

Which command did you issue to get those stats?

You might want to keep an eye on that, if it continues request to be moved.


#11

A load of 12 is still 10 more than it should be. The average load shouldn’t be higher than 1 for each core… DH systems having two CPU’s the load should stay around 2. The load on my server is often around 2, but then goes up to 5-6 but it’s sill fast at that.

Jan

Promo-Code: [color=#CC0000]SAVEMONEY97[/color] - Save [color=#CC0000]$50[/color] on your first year of hosting.
Get more promo codes here


#12

try: top

Jan

Promo-Code: [color=#CC0000]SAVEMONEY97[/color] - Save [color=#CC0000]$50[/color] on your first year of hosting.
Get more promo codes here


#13

My sites also seem to take forever to load, especially php/mysql apps.
The following loads are high according to the previous post (and, the first number was 11.00 the first time I checked).

The previous post says that loads should be around 2. Are these high loads why my sites are so slow?
The top command gives:
top - 17:05:54 up 10 days, 5:20, 10 users, load average: 6.69, 7.66, 6.68
Tasks: 2 total, 1 running, 1 sleeping, 0 stopped, 0 zombie
Cpu(s): 71.2% user, 17.5% system, 0.0% nice, 11.3% idle
Mem: 4075060k total, 3921412k used, 153648k free, 17148k buffers
Swap: 6313512k total, 275744k used, 6037768k free, 1903444k cached


#14

The load is above average, a little too high - but not really that high that it would greatly impact your website. The free memory is also fine (the buffered and cached memory is also basically ‘free memory’).

In my experience the MySQL is the real bottleneck here at DH, but you can’t really check to load on that machine which is seperate from your webserver. The only thing you could do is to login with phpMyAdmin and click on “Show MySQL runtime information”. There is a line with “Query statistics” which shows how much queries the MySQL server gets. Since DH moved me to a new MySQL server is has been 8-12 queries/second which is really good compared to other servers I’m hosting stuff on (others have 90-100 queries/second). However those servers with 90-100 queries/second still seem to run much faster than the DH servers with 8-12 queries/second - a thing I still can’t figure out, maybe DH is running multiple MySQL servers on a single physical host machine. Anyway, I would say if that query count is to high - on a DH level - it could indicate that the MySQL server is overloaded.

Jan

Promo-Code: [color=#CC0000]SAVEMONEY97[/color] - Save [color=#CC0000]$50[/color] on your first year of hosting.
Get more promo codes here


#15

[quote]Tasks: 2 total, 1 running, 1 sleeping, 0 stopped, 0 zombie
Cpu(s): 71.2% user, 17.5% system, 0.0% nice, 11.3% idle[/quote]
One running task and >70% user CPU :open_mouth:

Email Support next time you see that with the details and state that it’s happening “NOW”.


#16

Slow loading seems to correspond with high server load.

The queries/second are around 11, but the server load is:

top - 10:32:01 up 11 days, 22:46, 7 users, load average: 41.68, 38.39, 33.83
Tasks: 2 total, 1 running, 1 sleeping, 0 stopped, 0 zombie
Cpu(s): 61.0% user, 39.0% system, 0.0% nice, 0.0% idle
Mem: 4075060k total, 3903504k used, 171556k free, 12576k buffers
Swap: 6313512k total, 197976k used, 6115536k free, 1267392k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11417 cyclingu 9 0 1664 1664 1220 S 0.0 0.0 0:00.03 bash
27286 cyclingu 9 0 1020 1020 844 R 0.0 0.0 0:00.15 top

I have an inquiry into support, but haven’t heard back yet.


#17

Yes, 41 is definitely too high. Support will probably just restart the server.

Jan

Promo-Code: [color=#CC0000]SAVEMONEY97[/color] - Save [color=#CC0000]$50[/color] on your first year of hosting.
Get more promo codes here