salve
ho un server con debian 6 utilizzato solo per mysql con disco ssd da 60gb
ho fatto un report con mysqlreport e mysqltuner
se potete aiutatemi a capire come interpretare delle parti
Codice:
[--] Up for: 3d 7h 14m 20s (84M q [295.450 qps], 8M conn, TX: 426B, RX: 19B)
[--] Reads / Writes: 27% / 73%
[--] Total buffers: 504.0M global + 19.2M per thread (200 max threads)
[OK] Maximum possible memory usage: 4.2G (54% of installed RAM)
[OK] Slow queries: 0% (179/84M)
[OK] Highest usage of available connections: 68% (137/200)
[OK] Key buffer size / total MyISAM indexes: 312.0M/434.0M
[OK] Key buffer hit rate: 100.0% (3B cached / 258K reads)
[OK] Query cache efficiency: 78.7% (17M cached / 22M selects)
[!!] Query cache prunes per day: 1255
[OK] Sorts requiring temporary tables: 10% (155K temp sorts / 1M sorts)
[!!] Temporary tables created on disk: 44% (956K on disk / 2M total)
[OK] Thread cache hit rate: 99% (137 created / 8M connections)
[OK] Table cache hit rate: 41% (610 open / 1K opened)
[OK] Open file limit used: 18% (802/4K)
[!!] Table locks acquired immediately: 74%

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Optimize queries and/or use InnoDB to reduce lock wait
Variables to adjust:
    query_cache_size (> 128M)
    tmp_table_size (> 64M)
    max_heap_table_size (> 64M)


MySQL 5.1.49-3-log       uptime 3 7:15:48       Sun Oct 16 12:16:49 2011
__ Key _________________________________________________________________
Buffer used   181.14M of 312.00M  %Used:  58.06
  Current     223.14M            %Usage:  71.52
Write hit      94.43%
Read hit       99.99%

__ Questions ___________________________________________________________
Total          84.32M   295.5/s
  Com_         40.06M   140.4/s  %Total:  47.51
  QC Hits      17.94M    62.9/s           21.28
  DMS          17.72M    62.1/s           21.01
  COM_QUIT      8.60M    30.1/s           10.20
  -Unknown      2.66k     0.0/s            0.00
Slow 1 s          179     0.0/s            0.00  %DMS:   0.00  Log:  ON
DMS            17.72M    62.1/s           21.01
  UPDATE        8.50M    29.8/s           10.08         47.98
  SELECT        4.87M    17.1/s            5.77         27.48
  INSERT        4.11M    14.4/s            4.87         23.18
  DELETE      239.49k     0.8/s            0.28          1.35
  REPLACE           0       0/s            0.00          0.00
Com_           40.06M   140.4/s           47.51
  set_option   32.04M   112.3/s           38.00
  change_db     8.01M    28.1/s            9.50
  admin_comma   1.27k     0.0/s            0.00

__ SELECT and Sort _____________________________________________________
Scan            1.45M     5.1/s %SELECT:  29.83
Range         856.06k     3.0/s           17.58
Full join         393     0.0/s            0.01
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan       1.16M     4.1/s
Sort range    308.16k     1.1/s
Sort mrg pass 155.73k     0.5/s

__ Query Cache _________________________________________________________
Memory usage   63.23M of 128.00M  %Used:  49.40
Block Fragmnt  25.86%
Hits           17.94M    62.9/s
Inserts         3.97M    13.9/s
Insrt:Prune  940.49:1    13.9/s
Hit:Insert     4.53:1

__ Table Locks _________________________________________________________
Waited          6.31M    22.1/s  %Total:  25.61
Immediate      18.32M    64.2/s

__ Tables ______________________________________________________________
Open              610 of 2048    %Cache:  29.79
Opened          1.46k     0.0/s

__ Connections _________________________________________________________
Max used          137 of  200      %Max:  68.50
Total           8.60M    30.1/s

__ Created Temp ________________________________________________________
Disk table    956.68k     3.4/s
Table           1.21M     4.3/s    Size:  64.0M
File          310.83k     1.1/s

__ Threads _____________________________________________________________
Running             6 of   10
Cached            127 of  256      %Hit:    100
Created           137     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients         2.61k     0.0/s
Connects          184     0.0/s

__ Bytes _______________________________________________________________
Sent          426.81G    1.5M/s
Received       19.78G   69.3k/s
per mysqltuner o seguito le indicazioni
per mysqlreport
stavo seguendo la guida sul sito su come interpretare i dati
finora ho capito che potrei aumentare key_buffer_size
anche se non è ancora necessario
poi ho letto "vabbe diciamo che ho cercato di capire non sono ferrato in inglese"
che se com_ è alto allora il server ha dei problemi
ma purtroppo non ci ho capito molto nella guida sembra che non specifica cosa si puo fare per capire il problema e risolverlo
quindi volevo sapere cosa significa questa parte

Codice:
Com_           40.06M   140.4/s           47.51
  set_option   32.04M   112.3/s           38.00
  change_db     8.01M    28.1/s            9.50
  admin_comma   1.27k     0.0/s            0.00
se poi sapeta anche come risolvere e quindi spiegarmelo
ve ne sarei grato
ma già sapere di cosa si tratta da questo potrei partire a cercare una soluzione
fatemi sapere
grazie