Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 08-08-2004, 09:33 AM   #1
LQ Newbie
Registered: May 2004
Posts: 15

Rep: Reputation: 0
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
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
2)tail -10 mysqld.err
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
#password = my_password
port = 3306
socket = /var/run/mysqld/mysqld.sock

err-log = /var/log/mysql/mysql.err

#append end
user = mysql
pid-file = /var/run/mysqld/
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
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 =
port = 3306
# this can make it even more secure:

set-variable = max_allowed_packet=1M

#no-auto-rehash # faster start of mysql but no tab completition

set-variable = key_buffer=16M
Old 08-09-2004, 07:36 PM   #2
LQ Newbie
Registered: May 2004
Posts: 15

Original Poster
Rep: Reputation: 0
can sb help me?
Old 08-10-2004, 02:04 AM   #3
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
For all I know (and without knowing your CPU)
that might be normal? :)



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dual system boot err: rootnoverify(hd1,0),but the hd0 err msg existed befor shut down lilipeng24 Linux - General 3 06-25-2005 12:10 PM
Output of 'top' as backgrond Burgin Linux - General 2 06-09-2005 05:18 PM
openBSD - mysqld get error server version - please help me b:z *BSD 2 05-31-2005 04:01 AM
Odd output of 'top' philforrest Linux - General 1 07-20-2004 12:05 AM
web browsers slow, little memory free, pleae review output from top jeffreybluml Linux - Newbie 31 07-03-2004 08:15 PM

All times are GMT -5. The time now is 10:14 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration