27/07/2009, 11:26
|
| | Fecha de Ingreso: junio-2008
Mensajes: 105
Antigüedad: 16 años, 6 meses Puntos: 1 | |
Analizar el Top de mi Dedicado... Tengo una CPU Core2quad Q8200 con 2gb de Ram
Código:
top - 13:12:34 up 2 days, 14:50, 1 user, load average: 3.52, 2.66, 2.05
Tasks: 308 total, 1 running, 306 sleeping, 0 stopped, 1 zombie
Cpu(s): 8.2%us, 0.8%sy, 0.0%ni, 90.3%id, 0.6%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 2065284k total, 1971916k used, 93368k free, 4580k buffers
Swap: 4209020k total, 622244k used, 3586776k free, 65716k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
30653 apache 15 0 33124 16m 3388 S 10.6 0.8 0:00.33 httpd
30366 apache 16 0 0 0 0 Z 7.0 0.0 0:01.36 httpd <defunct>
30824 apache 16 0 33816 17m 3392 S 7.0 0.9 0:03.58 httpd
30373 apache 15 0 33260 16m 3304 S 6.6 0.8 0:00.72 httpd
17671 mysql 15 0 196m 22m 2780 S 1.3 1.1 6:23.71 mysqld
2082 root 15 0 1672 376 324 S 0.7 0.0 18:51.40 klogd
30413 apache 15 0 33940 17m 3424 S 0.7 0.9 0:01.64 httpd
2079 root 15 0 1720 512 464 S 0.3 0.0 24:18.71 syslogd
30320 apache 15 0 32708 4740 3252 S 0.3 0.2 0:00.26 httpd
30520 apache 15 0 33872 17m 3528 S 0.3 0.9 0:01.13 httpd
30697 apache 15 0 33196 16m 3284 S 0.3 0.8 0:00.85 httpd
30732 apache 18 0 33300 16m 3252 S 0.3 0.8 0:00.71 httpd
30904 apache 15 0 33460 16m 3280 S 0.3 0.8 0:01.25 httpd
30926 root 15 0 10140 2856 2296 S 0.3 0.1 0:00.03 sshd
30974 root 15 0 2328 1144 796 R 0.3 0.1 0:00.05 top
1 root 15 0 2064 472 448 S 0.0 0.0 0:01.45 init
Este es mi archivos my.cnf
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=1024
key_buffer=92M
join_buffer=16M
record_buffer=16M
sort_buffer_size=16M
read_buffer_size=8M
myisam_sort_buffer_size=64M
# 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
Espero y me ayuden a resolver este problema cave decir que tengo wordpress y una base de datos de 50mg espero y me ayuden.... ahora mismo hay 170 usuarios online |