Ništa mi ne rekoše o prirodi te aktivnosti, dali je previše querija, ili bandwith ili ovih 8 slow (koji su najverovatnije nastali tokom zaglupljivanja servera, dešava im se povremeno), ili šta već.
Može li me neko uputiti na šta ovde da obratim pažnju i u kom smeru da pokušam optimizaciju:
1 MySQL 5.1.26-rc-5.1.26r uptime 1 5:52:14 Fri Mar 4 13:25:03 2011
2
3 __ Key _________________________________________________________________
4 Buffer used 13.34M of 24.00M %Used: 55.60
5 Current 17.80M %Usage: 74.15
6 Write hit 27.55%
7 Read hit 99.96%
8
9 __ Questions ___________________________________________________________
10 Total 731.81k 6.8/s
11 QC Hits 406.56k 3.8/s %Total: 55.56
12 DMS 216.63k 2.0/s 29.60
13 Com_ 87.41k 0.8/s 11.94
14 COM_QUIT 21.27k 0.2/s 2.91
15 -Unknown 70 0.0/s 0.01
16 Slow 8 0.0/s 0.00 %DMS: 0.00
17 DMS 216.63k 2.0/s 29.60
18 SELECT 201.95k 1.9/s 27.60 93.22
19 UPDATE 6.58k 0.1/s 0.90 3.04
20 INSERT 5.75k 0.1/s 0.79 2.65
21 REPLACE 1.29k 0.0/s 0.18 0.59
22 DELETE 1.07k 0.0/s 0.15 0.50
23 Com_ 87.41k 0.8/s 11.94
24 set_option 63.21k 0.6/s 8.64
25 change_db 21.00k 0.2/s 2.87
26 show_tables 1.80k 0.0/s 0.25
27
28 __ SELECT and Sort _____________________________________________________
29 Scan 62.88k 0.6/s %SELECT: 31.13
30 Range 2.06k 0.0/s 1.02
31 Full join 0 0/s 0.00
32 Range check 0 0/s 0.00
33 Full rng join 0 0/s 0.00
34 Sort scan 49.83k 0.5/s
35 Sort range 4.33k 0.0/s
36 Sort mrg pass 935 0.0/s
37
38 __ Query Cache _________________________________________________________
39 Memory usage 8.74M of 12.00M %Used: 72.82
40 Block Fragmnt 8.51%
41 Hits 406.56k 3.8/s
42 Inserts 162.15k 1.5/s
43 Insrt:Prune 1.40:1 0.4/s
44 Hit:Insert 2.51:1
45
46 __ Table Locks _________________________________________________________
47 Waited 28 0.0/s %Total: 0.01
48 Immediate 244.48k 2.3/s
49
50 __ Tables ______________________________________________________________
51 Open 453 of 1024 %Cache: 44.24
52 Opened 831 0.0/s
53
54 __ Connections _________________________________________________________
55 Max used 8 of 60 %Max: 13.33
56 Total 21.28k 0.2/s
57
58 __ Created Temp ________________________________________________________
59 Disk table 40.07k 0.4/s
60 Table 42.31k 0.4/s
61 File 1.88k 0.0/s
62
63 __ Threads _____________________________________________________________
64 Running 1 of 1
65 Cached 3 of 4 %Hit: 99.44
66 Created 120 0.0/s
67 Slow 0 0/s
68
69 __ Aborted _____________________________________________________________
70 Clients 8 0.0/s
71 Connects 16 0.0/s
72
73 __ Bytes _______________________________________________________________
74 Sent 2.01G 18.6k/s
75 Received 93.62M 870.7/s