Need some help with server config on Debian 6, 32 bit

[bros]

Forum: www.mushroom-kingdom.info/boards
Status.php: www.mushroom-kingdom.info/boards/status.php
Phpinfo: www.mushroom-kingdom.info/p!p!nfo.php

I'm on a linode VPS. The 512. So I have an 8 core E5-2670 @ 2.6 GhZ with 512 MB RAM

The forum has 703424 Posts in 33931 Topics by 3814 Members. During peak time, there are an average of 60 users on for hours at a time. So not a lot of people compared to some bigger forums, but yeah.

Here's a list of the mods installed:


Pretty much using the default theme already, so there's that and I have already implemented the suggestions given in topics I have read (converted to InnoDB, etc.)

Edit: On one of the more popular boards, users are getting load times like: Page created in 1.799 seconds with 65 queries.

[LiroyvH]

So, what exactly is the problem, apart from the insane amount of queries per pageload?
Is it slow? Errors? Not working at all? Details..?

[bros]

So, what exactly is the problem, apart from the insane amount of queries per pageload?
Is it slow? Errors? Not working at all? Details..?

Crap.

Sorry.

A bit tired haha.

It's running slow. No errors.

It's running apache.

[LiroyvH]

Do you have caching enabled?
I'd also suggest putting nginx in front of it but that's up to you.

How large is your database?
Is it only slow with PHP or do you have sloweness for static files as well?
(Eg: got a test html file to show?)

[bros]

Do you have caching enabled?
I'd also suggest putting nginx in front of it but that's up to you.

How large is your database?
Is it only slow with PHP or do you have sloweness for static files as well?
(Eg: got a test html file to show?)

Caching is enabled. Level 2. XCache.

I'd do nginx, but i'm honestly not comfortable with it (also, any downtime and my users complain like there is no tomorrow).

Database is around 1.7 GB.

Here is a static file - http://mushroom-kingdom.info/bros.html

It's pretty slow too.

Here's a smaller HTML file - http://mushroom-kingdom.info/test.html

[LiroyvH]

The smaller HTML file loaded great. The larger one is indeed sloppy.

Well, it's a bit hard to say but either you have a very strange configuration somewhere OR your Linode is having major I/O problems.
The performance on the dynamic content, and the larger HTML file, is considerably poor. Considering the static page is loading quite slow as well, but your memory and CPU seem fine, you might want to ask Linode how I/O performance is on that particular node as it almost gives me the idea there is a problem in that area somewhere... Struggling to get the files.

But, that is of course without being able to look in to your system.

Also, now it doesn't matter too much because ANY php file, and the large static one lol, you have is slow; but 50MB buffer pool size on a 1.7GB database seems err... Quite very low.
But I understand you have memory constraints so setting it adequately high cannot be achieved on that VPS.

Either way, that from first glance doesn't seem to be the problem though... I personally expect either a misconfiguration in your Apache *OR* the VPS is having a massive struggle with hard drive I/O.

[bros]

The smaller HTML file loaded great. The larger one is indeed sloppy.

Well, it's a bit hard to say but either you have a very strange configuration somewhere OR your Linode is having major I/O problems.
The performance on the dynamic content, and the larger HTML file, is considerably poor. Considering the static page is loading quite slow as well, but your memory and CPU seem fine, you might want to ask Linode how I/O performance is on that particular node as it almost gives me the idea there is a problem in that area somewhere... Struggling to get the files.

But, that is of course without being able to look in to your system.

Also, now it doesn't matter too much because ANY php file, and the large static one lol, you have is slow; but 50MB buffer pool size on a 1.7GB database seems err... Quite very low.
But I understand you have memory constraints so setting it adequately high cannot be achieved on that VPS.

Either way, that from first glance doesn't seem to be the problem though... I personally expect either a misconfiguration in your Apache *OR* the VPS is having a massive struggle with hard drive I/O.

There's the IO stats.

Yeah a 50 MB buffer size is rather small.

I have about 700 MB in InnoDB tables according to mysqltuner.pl

[butch2k]

Could you check the dmesg for any errors ?
Could you check that PHP is not set as the html default handler in apache ?

[bros]

Could you check the dmesg for any errors ?
Could you check that PHP is not set as the html default handler in apache ?

I don't see any errors in dmesg
warning: `jsvc' uses 32-bit capabilities (legacy support in use)
AIF:UNPRIV connect attempt: IN=eth0 OUT= MAC=MAC_ADDRESS_HERE SRC: IPs DST: THE SERVER LEN=208 TOS=0x00 PREC=0x00 TTL=117 ID=25324 PROTO=UDP SPT=57305 DPT=9987 LEN=188
hrtimer: interrupt took 12869 ns

Where would I find that in apache?

I assume in apache2.conf, but where?

[bros]

Took ~15 seconds to load the index but I get Page created in 0.281 seconds with 11 queries.

[bros]

I'd also suggest putting nginx in front of it but that's up to you.

If I wanted to, how would I put nginx up in front of apache?

[LiroyvH]

It's really horribly slow. I wonder what your Apache is configured like, really...

For nginx, see:
http://www.ibualoy.net/blog/itech/linux/167-how-to-configure-nginx-and-apache-on-debian

That tutorial looks OK. (Haven't tested it, I don't run Debian)

[bros]

It's really horribly slow. I wonder what your Apache is configured like, really...

For nginx, see:
http://www.ibualoy.net/blog/itech/linux/167-how-to-configure-nginx-and-apache-on-debian

That tutorial looks OK. (Haven't tested it, I don't run Debian)

Want me to PM you my apache2.conf?

[butch2k]

Definitely an issue with Apache conf.

Trace route and ping: Fast
SMF Boards: Uber slow
Testing 403/404: Uber slow
Testing FTP: fast

[bros]

Mind if I PM you my apache conf?

[butch2k]

no problem send it my way. Include the vhost and modules' conf as well.

[bros]

I solved the issue I think.

I was making edits to mpm_worker

when I compiled apache with mpm_prefork

oops.

[butch2k]

Much better indeed !