Hi
I have a large forum, with more than 5K members, and hitting records of ard 200-300ppl online at the same time. 20K+ posts already in DB, and getting around 200-300posts per day.
Changed the DB tables to InnoDB as mentioned a thread here, but still experiencing some slowness, and even some "connection error to db" sometimes.
http://www.dharmasecrets.com/forum/status.php
my.cnf
==============================
[mysqld]
skip-locking
old-passwords
key_buffer = 256M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 32M
read_buffer_size = 32M
myisam_sort_buffer_size = 64M
thread_cache = 12
query_cache_size= 64M
thread_concurrency = 2
server-id = 1
max_connections = 512
max_user_connections = 15
interactive_timeout = 60
wait_timeout = 30
connect_timeout = 30
max_connect_errors = 5
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
[mysqlhotcopy]
interactive-timeout
http://www.simplemachines.org/community/index.php?topic=59691.0
What have you done so far?
it's a shared host
have mods like gogglebot mod, boardviewers, google member map
I just need for some people to look at my status.php and see how I can those within the range:
Opened vs. Open tables:
(table_cache) 660.7031 (should be <= 80)
Table cache usage:
(table_cache) 1 (should be >= 0.5 and <= 0.9)
Query cache prune rate:
(query_cache_size) 0.376 (should be <= 0.05)
Try doubling the table_cache, might even need tripling but start with double, same goes for query_cache_size