**Help in optmising large forum**

[Linlay]

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.

hxxp:www.dharmasecrets.com/forum/status.php [nonactive]


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

[Ben_S]

http://www.simplemachines.org/community/index.php?topic=59691.0

What have you done so far?

[Linlay]

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)

[Ben_S]

Try doubling the table_cache, might even need tripling but start with double, same goes for query_cache_size