Invision forum stalling, mytop output included

Once in a while, browsing the forum stalls for a short duration (2-3 minutes) I then ssh into the server and ran mytop. Here's the output. Could anyone tell me what's wrong? I know it's a mysql problem since it doesn't affect the other sites on the server. Thanks in advance. Invision forum stalling, mytop output included

MySQL on localhost (4.1.13-standard-log) up 3+00:23:49 [05:03:21]
Queries: 1.6M qps: 6 Slow: 25.0 Se/In/Up/De(%): 67/06/08/03
qps now: 1 Slow qps: 0.0 Threads: 35 ( 34/ 16) 00/00/00/00
Cache Hits: 548.4k Hits/s: 2.2 Hits now: 0.0 Ratio: 51.5% Ratio now: 0.0%
Key Efficiency: 99.9% Bps in/out: 1.8k/692.6 Now in/out: 54.2/737.0k

Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
108327 root localhost test 0 Query show full processlist
102540 root localhost test 3 Sleep
108331 celine4u_ localhost celine4u_i 10 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108330 celine4u_ localhost celine4u_i 12 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108329 celine4u_ localhost celine4u_i 17 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108328 celine4u_ localhost celine4u_i 21 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108326 celine4u_ localhost celine4u_i 30 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108325 celine4u_ localhost celine4u_i 38 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108324 celine4u_ localhost celine4u_i 39 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108318 celine4u_ localhost celine4u_i 40 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108319 celine4u_ localhost celine4u_i 40 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108313 celine4u_ localhost celine4u_i 44 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108312 celine4u_ localhost celine4u_i 48 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108311 celine4u_ localhost celine4u_i 52 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108310 celine4u_ localhost celine4u_i 54 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108309 celine4u_ localhost celine4u_i 62 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108308 celine4u_ localhost celine4u_i 63 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108307 celine4u_ localhost celine4u_i 64 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108306 celine4u_ localhost celine4u_i 66 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108305 celine4u_ localhost celine4u_i 70 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108303 celine4u_ localhost celine4u_i 71 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108304 celine4u_ localhost celine4u_i 71 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108301 celine4u_ localhost celine4u_i 78 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108300 celine4u_ localhost celine4u_i 80 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108285 celine4u localhost celine4u_i 88 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_posts`
108296 celine4u_ localhost celine4u_i 95 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108295 celine4u_ localhost celine4u_i 97 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333413
108294 celine4u_ localhost celine4u_i 102 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333412
108293 celine4u_ localhost celine4u_i 104 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333412
108291 celine4u_ localhost celine4u_i 110 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333412
108290 celine4u_ localhost celine4u_i 111 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333412
108289 celine4u_ localhost celine4u_i 112 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333412
108288 celine4u_ localhost celine4u_i 121 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333412
108287 celine4u_ localhost celine4u_i 127 Query SELECT * FROM ibf_sessions WHERE isfake='1' AND running_time>11333412
108286 celine4u_ localhost celine4u_i 134 Query UPDATE ibf_sessions SET member_name='uioop',member_id=2315,memb

 

 

 

 

Top