Tengo un servidor dedicado y hace semanas que el servicio web se está relentizando mucho, he estado viendo información para ver que puedo hacer pero no llego a ninguna solución.
Información del servidor dedicado:
Cita:
Ejecute el comando top:Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU 3040 @ 1.86GHz
Processor #1 speed: 1866.726 MHz
Processor #1 cache size: 2048 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(R) CPU 3040 @ 1.86GHz
Processor #2 speed: 1866.726 MHz
Processor #2 cache size: 2048 KB
Memory: 1033220k/1048320k available (1892k kernel code, 14448k reserved, 768k data, 192k init, 130816k highmem)
Sistema operativo: CENTOS Enterprise 4.6 i686 on standard - WHM X v3.1.0
Processor #1 Name: Intel(R) Xeon(R) CPU 3040 @ 1.86GHz
Processor #1 speed: 1866.726 MHz
Processor #1 cache size: 2048 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(R) CPU 3040 @ 1.86GHz
Processor #2 speed: 1866.726 MHz
Processor #2 cache size: 2048 KB
Memory: 1033220k/1048320k available (1892k kernel code, 14448k reserved, 768k data, 192k init, 130816k highmem)
Sistema operativo: CENTOS Enterprise 4.6 i686 on standard - WHM X v3.1.0
Cita:
PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
3202 mysql 15 0 100 88:49.86 3.8 178m 37m 4000 S mysqld
3202 mysql 15 0 100 88:49.86 3.8 178m 37m 4000 S mysqld
Configuracion mysql:
Cita:
No se como puedo solucionar el problema, y porque esta consumiendo toda la memoria ram, si se pudiera saber que consultas son las que consumen mas memoria..[mysqld]
datadir=/var/lib/mysql
skip-locking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=30
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=32M ## 32MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation_server=utf8_unicode_ci
character_set_server=utf8
[mysql.server]
user=mysql
#basedir=/var/lib
[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]
"my.cnf" 45L, 919C
datadir=/var/lib/mysql
skip-locking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=30
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=32M ## 32MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation_server=utf8_unicode_ci
character_set_server=utf8
[mysql.server]
user=mysql
#basedir=/var/lib
[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]
"my.cnf" 45L, 919C
Mode Lineal
