Analiza MySQL report-a

[ Miroslav Ćurčić @ 04.03.2011. 22:20 ] @

Dobio sam juče upozorenje od hosting provajdera (mt) o preteranoj aktivnosti MySQL servera i ponudili su mi ovaj log.

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:

Code:

  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