[Php-avanzado] Optimizando DB mysqltuner.pl

[gonzalo rama]

Hola, estoy corriendo el mysqltuner como user root, osea sobre todas las DB's.. tengo solo 3 db's y una que es la que es la de producción.
---------------como user root ---------------
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.51a-24+lenny3-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
[--] Data in MyISAM tables: 2G (Tables: 94)
[--] Data in InnoDB tables: 50M (Tables: 15)
[!!] Total fragmented tables: 5

-------- Performance Metrics -------------------------------------------------
[--] Up for: 10h 1m 22s (559K q [15.511 qps], 32K conn, TX: 330M, RX: 38M)
[--] Reads / Writes: 56% / 44%
[--] Total buffers: 74.0M global + 2.6M per thread (550 max threads)
[OK] Maximum possible memory usage: 1.5G (38% of installed RAM)
[!!] Slow queries: 17% (96K/559K)
[OK] Highest usage of available connections: 2% (11/550)
[OK] Key buffer size / total MyISAM indexes: 16.0M/2.6G
[OK] Key buffer hit rate: 99.9% (378M cached / 543K reads)
[OK] Query cache efficiency: 41.6% (141K cached / 339K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 65K sorts)
[!!] Temporary tables created on disk: 36% (32K on disk / 88K total)
[OK] Thread cache hit rate: 99% (22 created / 32K connections)
[!!] Table cache hit rate: 4% (64 open / 1K opened)
[OK] Open file limit used: 3% (83/2K)
[OK] Table locks acquired immediately: 99% (390K immediate / 390K locks)
[!!] InnoDB data size / buffer pool: 50.6M/8.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    tmp_table_size (> 32M)
    max_heap_table_size (> 16M)
    table_cache (> 64)
    innodb_buffer_pool_size (>= 50M)
--------------------------------------------------------

El sever tiene 4GB de memoria.... 
estas variables las maneja en memoria ? en el disco ?
    tmp_table_size (> 32M)

    max_heap_table_size (> 16M)

    table_cache (> 64)

    innodb_buffer_pool_size (>= 50M)
....
le asigno el doble de lo que me recomienda o lo mínimo  ?.. tambíen podría ir probando.. pero quizá haya algún patrón 

Gracias!.



      
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: http://www3.fi.mdp.edu.ar/pipermail/php-avanzado/attachments/20100910/1f4a734f/attachment-0001.htm