MySQL configuration for a forum

I have some problems with a phpBB forum for 100 users online where some times some process, (I’m using SHOW PROCESSLIST) take great time to execute, then when more users enter processlist increase, server load increase too and the server crawl.

I think mysql configuration of my host is not adequate, I think they are using default mysql values.

The variable “table_cache” is 64 that I think is too low causing mysql spend much time open and closing tables slowing down the server and the problem is not with my forum , but with MySQL server not configured adequately.



What is “good” configuration for MySQL for server with 1 GIG of RAM?

Is not good idea to enable query cahche with MySQL 4 ?



Some variables that I think is important from SHOW VARIABLES

connect_timeout 5

have_query_cache YES
query_cache_limit 1048576
query_cache_size 0
query_cache_type ON
query_prealloc_size 8192

join_buffer_size 131072
key_buffer_size 8388600

long_query_time 10

max_user_connections 0
max_tmp_tables 32
open_files_limit 2510

table_cache 64

version 4.0.18-standard
wait_timeout 28800

 

 

 

 

Top