Chinaunix

标题: [求助] mysql出现大量监听端口 [打印本页]

作者: mike_possible 时间: 2007-11-26 15:58
标题: [求助] mysql出现大量监听端口
最近开发的系统出现了一下问题：

当某个子进程运行时，/proc/(pid)/fd/出现大量如下连接，而且是每个查过的表都有一个。

lr-x------ 1 root root 64 Nov 26 15:43 0 -> /dev/null
l-wx------ 1 root root 64 Nov 26 15:43 1 -> /var/log/mysqld.log
lrwx------ 1 root root 64 Nov 26 15:43 10 -> socket:[127005]
lrwx------ 1 root root 64 Nov 26 15:43 100 -> /var/lib/mysql/AntiSpam_Gateway_db/spam94_tab.MYI
lrwx------ 1 root root 64 Nov 26 15:43 101 -> /var/lib/mysql/AntiSpam_Gateway_db/spam94_tab.MYD
lrwx------ 1 root root 64 Nov 26 15:43 102 -> /var/lib/mysql/AntiSpam_Gateway_db/spam95_tab.MYI
lrwx------ 1 root root 64 Nov 26 15:43 103 -> /var/lib/mysql/AntiSpam_Gateway_db/spam95_tab.MYD
lrwx------ 1 root root 64 Nov 26 15:43 104 -> /var/lib/mysql/AntiSpam_Gateway_db/spam96_tab.MYI
lrwx------ 1 root root 64 Nov 26 15:43 105 -> /var/lib/mysql/AntiSpam_Gateway_db/spam96_tab.MYD
lrwx------ 1 root root 64 Nov 26 15:43 106 -> /var/lib/mysql/AntiSpam_Gateway_db/spam97_tab.MYI
lrwx------ 1 root root 64 Nov 26 15:43 107 -> /var/lib/mysql/AntiSpam_Gateway_db/spam97_tab.MYD
lrwx------ 1 root root 64 Nov 26 15:43 108 -> /var/lib/mysql/AntiSpam_Gateway_db/spam98_tab.MYI
lrwx------ 1 root root 64 Nov 26 15:43 109 -> /var/lib/mysql/AntiSpam_Gateway_db/spam98_tab.MYD
..........
........

检查过程序，打开的mysql连接都已经关闭，而且pstree察看结果如下：

├─mysqld_safe───mysqld───9*[{mysqld}]

说明连接的释放没有问题。

用lsof发现有很多打开的端口：

mysqld 32031    mysql 10u    IPv4    116286                TCP *:mysql (LISTEN)
mysqld 32031    mysql 11u    REG    253,0       0 8028218 /tmp/ibz5Biq5 (deleted)
mysqld 32031    mysql 12u    unix 0xe8a54080             116287 /var/lib/mysql/mysql.sock
mysqld 32031    mysql 14u    REG    253,0    1024 1901720 /var/lib/mysql/AntiSpam_Gateway_db/spam80_tab.MYI
mysqld 32031    mysql 15u    REG    253,0       0 1901721 /var/lib/mysql/AntiSpam_Gateway_db/spam80_tab.MYD
mysqld 32031    mysql 16u    REG    253,0    1024 1901723 /var/lib/mysql/AntiSpam_Gateway_db/spam81_tab.MYI
mysqld 32031    mysql 17u    REG    253,0       0 1901724 /var/lib/mysql/AntiSpam_Gateway_db/spam81_tab.MYD
mysqld 32031    mysql 18u    REG    253,0    1024 1901726 /var/lib/mysql/AntiSpam_Gateway_db/spam82_tab.MYI
mysqld 32031    mysql 19u    REG    253,0       0 1901727 /var/lib/mysql/AntiSpam_Gateway_db/spam82_tab.MYD
mysqld 32031    mysql 20u    REG    253,0    1024 1901729 /var/lib/mysql/AntiSpam_Gateway_db/spam83_tab.MYI
mysqld 32031    mysql 21u    REG    253,0       0 1901730 /var/lib/mysql/AntiSpam_Gateway_db/spam83_tab.MYD
mysqld 32031    mysql 22u    REG    253,0    1024 1901732 /var/lib/mysql/AntiSpam_Gateway_db/spam84_tab.MYI
mysqld 32031    mysql 23u    REG    253,0       0 1901733 /var/lib/mysql/AntiSpam_Gateway_db/spam84_tab.MYD
mysqld 32031    mysql 24u    REG    253,0    1024 1901735 /var/lib/mysql/AntiSpam_Gateway_db/spam85_tab.MYI
mysqld 32031    mysql 25u    REG    253,0       0 1901736 /var/lib/mysql/AntiSpam_Gateway_db/spam85_tab.MYD
mysqld 32031    mysql 26u    REG    253,0    1024 1901738 /var/lib/mysql/AntiSpam_Gateway_db/spam86_tab.MYI
mysqld 32031    mysql 27u    REG    253,0       0 1901739 /var/lib/mysql/AntiSpam_Gateway_db/spam86_tab.MYD
mysqld 32031    mysql 28u    REG    253,0    1024 1901741 /var/lib/mysql/AntiSpam_Gateway_db/spam87_tab.MYI
mysqld 32031    mysql 29u    REG    253,0       0 1901742 /var/lib/mysql/AntiSpam_Gateway_db/spam87_tab.MYD
mysqld 32031    mysql 30u    REG    253,0    1024 1901744 /var/lib/mysql/AntiSpam_Gateway_db/spam88_tab.MYI
mysqld 32031    mysql 31u    REG    253,0       0 1901745 /var/lib/mysql/AntiSpam_Gateway_db/spam88_tab.MYD
mysqld 32031    mysql 32u    REG    253,0    1024 1901747 /var/lib/mysql/AntiSpam_Gateway_db/spam89_tab.MYI
mysqld 32031    mysql 33u    REG    253,0       0 1901748 /var/lib/mysql/AntiSpam_Gateway_db/spam89_tab.MYD
mysqld 32031    mysql 34u    REG    253,0    1024 1901750 /var/lib/mysql/AntiSpam_Gateway_db/spam90_tab.MYI
mysqld 32031    mysql 35u    REG    253,0       0 1901751 /var/lib/mysql/AntiSpam_Gateway_db/spam90_tab.MYD
mysqld 32031    mysql 36u    REG    253,0    1024 1901753 /var/lib/mysql/AntiSpam_Gateway_db/spam91_tab.MYI
mysqld 32031    mysql 37u    REG    253,0       0 1901754 /var/lib/mysql/AntiSpam_Gateway_db/spam91_tab.MYD
mysqld 32031    mysql 38u    REG    253,0    1024 1901756 /var/lib/mysql/AntiSpam_Gateway_db/spam92_tab.MYI
mysqld 32031    mysql 39u    REG    253,0       0 1901757 /var/lib/mysql/AntiSpam_Gateway_db/spam92_tab.MYD

.......................

换台机器，就没有这种现象了。

网上查了半天，也没有什么收获。

请问各位，有知道这是怎么回事的么？

作者: HonestQiao 时间: 2007-11-26 21:42
也许没啥奇怪的。

mysql可以保持打开的表方便被再次调用提高命中。

作者: yueliangdao0608 时间: 2007-11-26 21:52
你觉得奇怪可以直接KILL掉。

作者: mike_possible 时间: 2007-11-27 10:21
但是其他表并不出现这样的情况啊。

其他表在查询时会出现，查完也就消失了。

程序kill 掉后这些依然存在，重启mysql才会消失

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)