MyBB Community Forums

Hi All,

I'm very new to creating forums and started one a couple months back. It's been growing very fast and I've had to upgrade my hosting plan several times.

The issue now is that I'm already on hostgators level 6 VPS plan and they're still asking me to move to a dedicated because of my high CPU usage.

I don't think such a new forum should require so much from hosting...so I was hoping if you guys can take a look at my current settings to make sure everything is optimized.

Here's some info about my current forum:

plugins:
MyTheme (2.0)
Google SEO (1.6.3)

total of 140,157 posts in 19,265 threads
normally 200-300 members online at any given time.

my server load avg is normally around 10 and I only have 2 cores.

weird thing is my memory usage is very low, usually only 500mb of my 2304mb total.

here's my mysql config settings (I'm guessing a couple isn't correct):

[mysqld]
# Enable logging of slow queries
slow_query_log=1
slow_query_log_file=/var/log/mysql_slow_queries.log
safe-show-database
open_files_limit = 5000
tmp_table_size = 128M
innodb_buffer_pool_size=196M
max_heap_table_size = 128M

query_cache_limit=1M

query_cache_size=64M ## 32MB for every 1GB of RAM

query_cache_type=1

max_connections=100

collation_server=utf8_unicode_ci

character_set_server=utf8

delayed_insert_timeout=40

interactive_timeout=300

wait_timeout=300

connect_timeout=20

thread_cache_size=64

key_buffer=64M ## 32MB for every 1GB of RAM

join_buffer=1M

max_connect_errors=20

max_allowed_packet=8M

table_cache=1024

record_buffer=1M

sort_buffer_size=2M ## 1MB for every 1GB of RAM

read_buffer_size=2M ## 1MB for every 1GB of RAM

read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM

thread_concurrency=2 ## Number of CPUs x 2

myisam_sort_buffer_size=16M

innodb_file_per_table=1

Please help me!

(2012-11-07, 04:16 AM)NeoCHI Wrote: [ -> ]Hi All,

I'm very new to creating forums and started one a couple months back. It's been growing very fast and I've had to upgrade my hosting plan several times.

The issue now is that I'm already on hostgators level 6 VPS plan and they're still asking me to move to a dedicated because of my high CPU usage.

I don't think such a new forum should require so much from hosting...so I was hoping if you guys can take a look at my current settings to make sure everything is optimized.

Here's some info about my current forum:

plugins:
MyTheme (2.0)
Google SEO (1.6.3)

total of 140,157 posts in 19,265 threads
normally 200-300 members online at any given time.

my server load avg is normally around 10 and I only have 2 cores.

weird thing is my memory usage is very low, usually only 500mb of my 2304mb total.

here's my mysql config settings (I'm guessing a couple isn't correct):

[mysqld]
# Enable logging of slow queries
slow_query_log=1
slow_query_log_file=/var/log/mysql_slow_queries.log
safe-show-database
open_files_limit = 5000
tmp_table_size = 128M
innodb_buffer_pool_size=196M
max_heap_table_size = 128M

query_cache_limit=1M

query_cache_size=64M ## 32MB for every 1GB of RAM

query_cache_type=1

max_connections=100

collation_server=utf8_unicode_ci

character_set_server=utf8

delayed_insert_timeout=40

interactive_timeout=300

wait_timeout=300

connect_timeout=20

thread_cache_size=64

key_buffer=64M ## 32MB for every 1GB of RAM

join_buffer=1M

max_connect_errors=20

max_allowed_packet=8M

table_cache=1024

record_buffer=1M

sort_buffer_size=2M ## 1MB for every 1GB of RAM

read_buffer_size=2M ## 1MB for every 1GB of RAM

read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM

thread_concurrency=2 ## Number of CPUs x 2

myisam_sort_buffer_size=16M

innodb_file_per_table=1

Please help me!

in fact you only have these two plugins active?
you don't use any plugin against spammer or bot?

you really need google seo plugin? try desactive if reduce cpu usage...

my avg server load seems to be GROWING....it's actually around 24 now... but there's only 100 people on....it doesn't seem to be dependent on the number of users...instead it's just accumulating...

whats going on?!

Try to ask your host to put you on a VPS which offers 2 or 4 additional cores, that'll stabilize the load.

i'm in the middle of switching to a dedicated server but I'd also like to resolve whatever issue I'm currently experiencing.

It just doesn't seem normal...

What webserver are you using? Apache? If so, maybe take a look at making the switch to nginx. There's no way you need a dedicated server yet if all you are running is MyBB. Labrocca's Support Forums still runs on shared IIRC and he has 12k members and 265k posts.

(2012-11-07, 02:50 PM)euantor Wrote: [ -> ]What webserver are you using? Apache? If so, maybe take a look at making the switch to nginx. There's no way you need a dedicated server yet if all you are running is MyBB. Labrocca's Support Forums still runs on shared IIRC and he has 12k members and 265k posts.

you can provide name of host provider?
interested in this host

I believe he's with Dreamhost still. Not completely sure but I know he used to be a fan of them at least.

(2012-11-07, 03:08 PM)euantor Wrote: [ -> ]I believe he's with Dreamhost still. Not completely sure but I know he used to be a fan of them at least.

thanks provide this information...
because few shared host supports lots of visitors and posts...

Apache. I use hostgator for my hosting company.

What do you think the problem is?

Could it possibly be because of the high number of users on at any given time (200-300)? I'm just still trying to figure out if my hosting needs are normal for my traffic or not.

My hosting company says I need to optimize the website and that there's something wrong with the code. But I didn't change much so I can't think of anything I could have done to cause an issue.

What would using nginx do?