2012-11-07, 04:16 AM
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!
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!