List:General Discussion« Previous MessageNext Message »
From:J M Date:May 5 2011 6:42pm
Subject:Input needed...
View as plain text  
Hi,

  I have this stats:  I have tuned some of it but I was wondering if someone
can give inputs regarding it:

*
__ Key _________________________________________________________________
Buffer used    54.63M of 384.00M  %Used:  14.23
  Current     123.21M            %Usage:  32.09
Write hit      99.97%
Read hit      100.00%

__ Questions ___________________________________________________________
Total          87.40M    18.4/s
  QC Hits      50.63M    10.7/s  %Total:  57.93
  DMS          24.04M     5.1/s           27.50
  Com_          8.52M     1.8/s            9.75
  COM_QUIT      4.24M     0.9/s            4.85
  -Unknown     28.31k     0.0/s            0.03
Slow 10 s       9.21k     0.0/s            0.01  %DMS:   0.04  Log: OFF
DMS            24.04M     5.1/s           27.50
  SELECT       21.98M     4.6/s           25.14         91.41
  UPDATE        1.74M     0.4/s            1.99          7.24
  INSERT      211.35k     0.0/s            0.24          0.88
  DELETE      111.77k     0.0/s            0.13          0.46
  REPLACE           0       0/s            0.00          0.00
Com_            8.52M     1.8/s            9.75
  set_option    4.26M     0.9/s            4.87
  change_db     4.22M     0.9/s            4.83
  show_table_   9.33k     0.0/s            0.01

__ SELECT and Sort _____________________________________________________
Scan          838.37k     0.2/s %SELECT:   3.81
Range           2.12M     0.4/s            9.64
Full join         988     0.0/s            0.00
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan       3.71M     0.8/s
Sort range      3.63M     0.8/s
Sort mrg pass  82.85k     0.0/s

__ Query Cache _________________________________________________________
Memory usage    3.75M of  32.00M  %Used:  11.72
Block Fragmnt  28.39%
Hits           50.63M    10.7/s
Inserts        16.38M     3.4/s
Insrt:Prune   14.39:1     3.2/s
Hit:Insert     3.09:1

__ Table Locks _________________________________________________________
Waited         53.43k     0.0/s  %Total:   0.17
Immediate      31.57M     6.6/s

__ Tables ______________________________________________________________
Open              512 of  512    %Cache: 100.00
Opened          3.02k     0.0/s

__ Connections _________________________________________________________
Max used          145 of  802      %Max:  18.08
Total           4.24M     0.9/s

__ Created Temp ________________________________________________________
Disk table      3.61M     0.8/s
Table           3.72M     0.8/s    Size:  16.0M
File          165.71k     0.0/s

__ Threads _____________________________________________________________
Running            69 of   71
Cached              0 of    8      %Hit:  99.02
Created        41.74k     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients         6.48k     0.0/s
Connects       25.00k     0.0/s

__ Bytes _______________________________________________________________
Sent            1.18T  247.9k/s
Received       15.27G    3.2k/s*

Thread
Input needed...J M5 May
  • Re: Input needed...Reindl Harald5 May
    • Re: Input needed...J M6 May
      • RE: Input needed...Martin Gainty6 May
      • Re: Input needed...Reindl Harald6 May
        • RE: Input needed...Martin Gainty6 May
        • Re: Input needed...Peter Boros8 May