Hi
As you can see, there are some problemes :
- Table cache usage:
- Key buffer write hit rate:
- Thread cache usage
- Query cache miss rate
This is my.cnf. and the serveur is Pentium IV 3 Ghz with 1 Go memory
#key_buffer = 256M
key_buffer=256M
thread_stack=128K
max_allowed_packet = 1M
table_cache = 512
#sort_buffer_size = 1M
#read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 32
#query_cache_size= 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
query_cache_limit=1048576
query_cache_size=26214400
query_cache_type=1
wait_timeout=120
interactive_timeout=12000
max_connections=256
max_connect_errors=10000
