LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices



Reply
 
Search this Thread
Old 08-08-2004, 10:33 AM   #1
csstudy
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
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
 
Old 08-09-2004, 08:36 PM   #2
csstudy
LQ Newbie
 
Registered: May 2004
Posts: 15

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

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


Cheers,
Tink
 
  


Reply


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 01:10 PM
Output of 'top' as backgrond Burgin Linux - General 2 06-09-2005 06:18 PM
openBSD - mysqld get error server version - please help me b:z *BSD 2 05-31-2005 05:01 AM
Odd output of 'top' philforrest Linux - General 1 07-20-2004 01:05 AM
web browsers slow, little memory free, pleae review output from top jeffreybluml Linux - Newbie 31 07-03-2004 09:15 PM


All times are GMT -5. The time now is 11:11 PM.

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