MYSQL 动作不稳定

afdlove

070903 21:57:01  Aborted(1184) connection 1264 to db: 'sech' user: 'root' host:

`172.31.1.16' (Got an error reading communication packets(1158))
070903 21:57:01  Aborted connection 1265 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)
070903 21:57:01  Aborted connection 1263 to db: 'sech' user: 'root' host:

`localhost.localdomain' (Got an error reading communication packets)
070903 21:57:01  Aborted connection 1266 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)
070903 21:57:01  Aborted connection 1267 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)





070903 22:19:08  Aborted connection 1537 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)
070903 22:19:08  Aborted connection 1535 to db: 'sech' user: 'root' host:

`localhost.localdomain' (Got an error reading communication packets)
070903 22:19:08  Aborted connection 1539 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)
070903 22:19:08  Aborted connection 1536 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)
070903 22:19:08  Aborted connection 1538 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)




070903 22:56:37  Aborted connection 1641 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)
070903 22:56:37  Aborted connection 1637 to db: 'sech' user: 'root' host:

`localhost.localdomain' (Got an error reading communication packets)
070903 22:56:37  Aborted connection 1640 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)
070903 22:56:37  Aborted connection 1643 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)
070903 22:56:37  Aborted connection 1642 to db: 'sech' user: 'root' host: `172.31.1.16'

(Got an error reading communication packets)



以上是MYSQL的日志,mysql为什么这么不稳定。

它的不稳定，引起这个上面的一个业务系统不断重启。

环境是：RH9（2.6.8)+MYSQL 4.0.20

高手们可以帮我看看是什么问题引起的。

先谢了。

[ 本帖最后由 afdlove 于 2007-9-8 09:25 编辑 ]

yejr

先查下网络的问题,感觉你的系统太过繁忙,而网络带宽却不够

afdlove

原帖由 yejr 于 2007-9-8 14:33 发表
先查下网络的问题,感觉你的系统太过繁忙,而网络带宽却不够

2850,4个逻辑CPU，占用率有时70-80%左右， 有时10-20%左右
4G MEMERY，占用，系统重启那会是：1G左右，慢慢会占到2G，或3G。
这个MYSQL是自己和自己联，它不会主动联别人，别人也不会联过来。
兄台所说的“网络带宽不够”是什么意思？这个172.31.1.16'是100M带宽，基本没有过多的数据包。流量不会超过1M。
对DB不熟悉，请明示。
过几天，我把MY。CNF文件帖上来。

[ 本帖最后由 afdlove 于 2007-9-8 16:33 编辑 ]

yejr

嗯，另外用mysqlreport的结果也发上来一份

afdlove

mysqlreport报错，看来，我的系统还要装：Perl DBI模块和MySQL DBD

到现场了，我再发，先谢谢yejr兄台。

afdlove

[root@localhost var]# more my.cnf
# This is for large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 16M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-bin
server-id       = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
[root@localhost var]#

afdlove

DELL  2850,2CPU,8GMEM  420G HDD

showsa

http://forums.mysql.com/read.php?21,108326,127540#msg-127540

上面说是网络问题

也可能是你的系统有问题

afdlove

看来，只有重做系统了？