Código:
Este es mi archivos my.cnftop - 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
Código:
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 # 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
