Ver Mensaje Individual
  #1 (permalink)  
Antiguo 27/07/2009, 11:26
Chismopoly
 
Fecha de Ingreso: junio-2008
Mensajes: 105
Antigüedad: 15 años, 11 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