News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Whats Wrong ?

Started by Stealth1, November 10, 2010, 04:40:38 PM

Previous topic - Next topic

Stealth1

My forum has been taking too much bandwith and slow for the past days

Basic Information
November 10, 2010, 03:29:36 PM
Operating System:   CentOS release 5.5 (Final)
Processor:   Intel® Xeon® CPU E5520 @ 2.27GHz (2267.006MHz)
Load averages:   3.81, 4.14, 3.45
Current processes:   4 (3 sleeping, 1 running, 0 zombie)
Processes by CPU:   (other) (4) 0.0%
Memory usage:    90.752% (11160464k / 12297700k)
Swap: 11.814% (248632k / 2104504k)
MySQL Statistics
MySQL 5.0.x
Connections per second:    4.6418
Kilobytes received per second:    45.1779
Kilobytes sent per second:    606.5775
Queries per second:    221.1532
Percentage of slow queries:    0
Opened vs. Open tables:
(table_cache)    339.9835 (should be <= 80)
Table cache usage:
(table_cache)    1 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size)    0.003 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size)    0.1013 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size)    6659.72 (should be >= 30 )
Thread cache usage:
(thread_cache_size)    0.3594 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size)    0.519 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer)    0.0001 (should be <= 0.001)
Query cache enabled:
(query_cache_type)    1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit)    0.3907 (should be <= 0.5)
Query cache prune rate:
(query_cache_size)    0 (should be <= 0.05)

kat

Do you have a shoutbox, or chatroom, set to "Real Time"?

That'd do it.

Fussilet


JimM

Any updates on this.  Did the link that Fussilet posted give you any ideas of things to try? 
Jim "JimM" Moore
Former Support Specialist

Advertisement: