Aquí esta my.cnf y la verdad es que el servidor es administrado por mi y no tengo los fondos suficiente para pagar una empresa que me administre el servidor... por eso voy a tratar de yo hacerlo lo mejor posible y así aprender mas... gracia por su ayuda
Código:
# The following options will be passed to all MySQL clients
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
[mysql.server]
user=mysql
basedir=/var/lib
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#
skip-innodb
skip-locking
# CONNECTION LIMITS
max_connection = 2000
max_user_connections = 5000
# QUERY-CACHE
query_cache_limit=16M
query_cache_size=64M
query_cache_type=1
log-slow-queries=/var/log/mysql-slow-queries.log
long_query_time = 5
log-queries-not-using-indexes
# TIMEOUTS
interactive_timeout=20
wait_timeout=20
connect_timeout=6
max_connect_errors=10
# TUNING
max_allowed_packet=16M
thread_cache_size=192
table_cache=2024
key_buffer=184M
join_buffer=32M
record_buffer=32M
sort_buffer_size=32M
read_buffer_size=16M
myisam_sort_buffer_size=128M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4
# Don't listen on a TCP/IP port at all. This can be a security enhancement.
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
#log-bin
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Aquí esta de nuevo el Análisis de MySQLTuner script lo vi de nuevo y me dios otros dato y ya mysql tiene 1 dia y 18h arriba en el otro tenia 19h
Cita: -------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.45-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: 73M (Tables: 70)
[!!] BDB is enabled but isn't being used
[!!] Total fragmented tables: 1
-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 18h 47m 32s (5M q [38.899 qps], 291K conn, TX: 4B, RX: 845M)
[--] Reads / Writes: 97% / 3%
[--] Total buffers: 274.0M global + 80.4M per thread (2000 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 157.4G (3987% of installed RAM)
[OK] Slow queries: 2% (135K/5M)
[OK] Highest usage of available connections: 6% (136/2000)
[OK] Key buffer size / total MyISAM indexes: 184.0M/34.8M
[OK] Key buffer hit rate: 99.6% (1B cached / 6M reads)
[OK] Query cache efficiency: 63.3% (3M cached / 5M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 732K sorts)
[!!] Temporary tables created on disk: 45% (333K on disk / 732K total)
[OK] Thread cache hit rate: 99% (136 created / 291K connections)
[!!] Table cache hit rate: 0% (37 open / 35K opened)
[OK] Open file limit used: 0% (66/10K)
[OK] Table locks acquired immediately: 99% (2M immediate / 2M locks)
-------- Recommendations -----------------------------------------------------
General recommendations:
Add skip-bdb to MySQL configuration to disable BDB
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
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
tmp_table_size (> 32M)
max_heap_table_size (> 16M)
table_cache (> 2024)