Ver Mensaje Individual
  #35 (permalink)  
Antiguo 25/03/2010, 16:50
kepardox
 
Fecha de Ingreso: junio-2005
Mensajes: 36
Antigüedad: 19 años
Puntos: 1
Respuesta: Necesito ayuda para optimizar mi servidor

Si. Es el mismo server. El resultado de which mysql es: /usr/bin/mysql

Los archivos están tal cual lo publicaste. Lo copié y pegué para subirlo y descargarlo con wget. Siento vergüenza decirlo, pero no sé cómo rayos copiar y pegar en el putty.

A parte de esto comenzaron a aparecer problemas :( ... Resulta que ahora hay muchas más visitas que antes (casi el doble) y el server comenzó a sentirlo... vamos, se sobrecarga. Vi el resultado de mysqltuner... y me recomienda subir las conexiones; lo hice, pero supongo que aún faltan ciertas cosillas.

El resultado de mysqltuner es:


>> MySQLTuner 1.0.1 - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.89-community-log
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 78M (Tables: 127)
[--] Data in InnoDB tables: 96K (Tables: 6)
[!!] Total fragmented tables: 30

-------- Performance Metrics -------------------------------------------------
[--] Up for: 20h 42m 41s (6M q [82.960 qps], 278K conn, TX: 3B, RX: 639M)
[--] Reads / Writes: 87% / 13%
[--] Total buffers: 410.0M global + 33.4M per thread (200 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 6.9G (87% of installed RAM)
[OK] Slow queries: 0% (274/6M)
[OK] Highest usage of available connections: 40% (80/200)
[OK] Key buffer size / total MyISAM indexes: 16.0M/35.1M
[OK] Key buffer hit rate: 100.0% (1B cached / 140K reads)
[OK] Query cache efficiency: 80.2% (4M cached / 5M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 234K sorts)
[!!] Temporary tables created on disk: 49% (86K on disk / 173K total)
[OK] Thread cache hit rate: 99% (80 created / 278K connections)
[OK] Table cache hit rate: 47% (256 open / 542 opened)
[OK] Open file limit used: 9% (395/4K)
[OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)
[OK] InnoDB data size / buffer pool: 96.0K/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
Variables to adjust:
tmp_table_size (> 128M)
max_heap_table_size (> 128M)


Gracias por la ayuda!