linux server very slow about top output and mysqld.err
linux server very slow about top output and mysqld.err
my server(apache+mysql+proftpd) is very slow for web access. 1)I use top commonand,see that the cpus us is very high,(about 80-94%)£¬and top shows that too much myslqd process(about 10-20 process). Tasks: 428 total, 18 running, 410 sleeping, 0 stopped, 0 zombie Cpu(s): 90.1% us, 8.0% sy, 0.0% ni, 0.2% id, 0.3% wa, 0.3% hi, 1.1% si Mem: 904876k total, 864428k used, 40448k free, 17816k buffers Swap: 1004052k total, 205988k used, 798064k free, 272132k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 11662 mysql 21 0 262m 78m 6212 R 48.3 8.9 0:03.29 mysqld 11700 mysql 16 0 262m 78m 6212 S 41.8 8.9 0:01.69 mysqld 11664 mysql 15 0 262m 78m 6212 S 39.2 8.9 0:03.31 mysqld 11271 mysql 15 0 261m 75m 6212 S 22.0 8.5 0:01.15 mysqld ......more 2)tail -10 mysqld.err ckets) 040808 20:52:29 Aborted connection 416537 to db: 'disc' user: 'root' host: `localhost' (Got timeout reading communication packets) 040808 20:58:39 Aborted connection 417707 to db: 'dis' user: 'root' host: `localhost' (Got an error reading communication packets) 040808 21:16:36 Aborted connection 420414 to db: 'dis' user: 'root' host: `localhost' (Got timeout reading communication packets) 040808 21:24:03 Aborted connection 421471 to db: 'dis' user: 'root' host: `localhost' (Got timeout reading communication packets) 040808 21:27:04 Aborted connection 421999 to db: 'dis' user: 'root' host: `localhost' (Got timeout reading communication .........more 3)my.cnf [client] #password = my_password port = 3306 socket = /var/run/mysqld/mysqld.sock [safe_mysqld] err-log = /var/log/mysql/mysql.err [mysqld] skip-innodb #append skip-bdb skip-name-resolve #append end user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock log-error = /var/log/mysql/mysqld.err #server-id = 207 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english set-variable = max_connections=512 skip-locking #skip-networking set-variable = key_buffer=128M set-variable =max_allowed_packet=2M set-variable =table_cache=800 set-variable = sort_buffer=16M set-variable = record_buffer=16M set-variable = thread_cache=16 set-variable = thread_stack=128K set-variable = thread_concurrency=8 set-variable = myisam_sort_buffer_size=64M set-variable = long_query_time=1 set-variable = wait_timeout=80 set-variable = interactive_timeout=120 # keep secure by default! bind-address = 0.0.0.0 port = 3306 # this can make it even more secure: #skip-networking [mysqldump] quick set-variable = max_allowed_packet=1M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] set-variable = key_buffer=16M |
can sb help me?
|
For all I know (and without knowing your CPU)
that might be normal? :) Cheers, Tink |
All times are GMT -5. The time now is 05:23 PM. |