Advertisement:

Author Topic: Help me with my config ->  (Read 3993 times)

Offline ArkServer

  • SMF Hero
  • ******
  • Posts: 1,831
  • My posts are my own
    • BlushyFace | A spoopy and creppy site
Help me with my config ->
« on: March 09, 2006, 11:47:36 AM »
 Connections per second:      0.0339
Kilobytes received per second:    0.2333
Kilobytes sent per second:    1.1628
Queries per second:    0.8518
Percentage of slow queries:    0
Opened vs. Open tables:
(table_cache)    24.9286 (should be <= 80)
Table cache usage:
(table_cache)    0.0289 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size)    0.01 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size)    0.9522 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size)    327.75 (should be >= 30 )
Thread cache usage:
(thread_cache_size)    0.0625 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size)    0.5429 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer)    0.0005 (should be <= 0.001)
Query cache enabled:
(query_cache_type)    1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit)    0 (should be <= 0.1)
Query cache prune rate:
(query_cache_size)    0 (should be <= 0.05)


Some of these are in bold and i have no clue how to optimize it. I edited the sel config file but i see no improvements.

the machine is not dedicated. running 1.1 rc2 , page load time: 1+ sec

www.happyserver.be
« Last Edit: March 09, 2006, 11:49:44 AM by ArkServer »