Advertisement:

Author Topic: Need somes advices to improve speed  (Read 3935 times)

Offline bjp

  • Jr. Member
  • **
  • Posts: 163
Need somes advices to improve speed
« on: August 06, 2005, 03:47:32 AM »
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
« Last Edit: August 06, 2005, 04:27:11 PM by bjp »

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: Need somes advices to improve speed
« Reply #1 on: August 06, 2005, 03:00:45 PM »
Your forum really doesn't seem slow to me.  Where is it slow?

-[Unknown]