Linux最大连接数问题

最新推荐文章于 2024-10-29 21:15:14 发布

原创最新推荐文章于 2024-10-29 21:15:14 发布 · 645 阅读

CC 4.0 BY-SA版权

在运行程序并频繁进行MySQL操作时，可能会遇到由于系统限制导致的'Can't open file...'异常，这通常与Linux的最大文件打开数有关。通过查看'/etc/security/limits.conf'配置文件，发现已将soft和hard nofile限制设置为65535，但依然出现错误。解决此类问题可能需要调整系统级别的文件描述符限制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

程序在大量进行mysql操作时，偶尔会遇到类似这样的异常：“Can't open file: './etl/etl_portal_offline_20160316.frm' (errno: 24”

016-03-17 02:30:14.011 INFO com.maipu.analyse.plugins.AbstractAnalyzer.excuteUpdateSql(AbstractAnalyzer.java:229) - <ExcuteUpdateSql success inffect row10000 use 2084 sql=DELETE FROM A_RegistUserStatEveryWeek WHERE stat_week=1458403200000>

2016-03-17 02:30:15.791 ERROR com.maipu.analyse.plugins.AbstractAnalyzer.excuteSelectSql(AbstractAnalyzer.java:323) - <ExcuteSelectSql exception for sql SELECT id,user,online_time,occurence_time_milli,group_code,user_mac,user_ip FROM etl.ETL_PORTAL_OFFLINE_20160316 limit 0, 10000>

java.sql.SQLException: Can't open file: './etl/etl_portal_offline_20160316.frm' (errno: 24)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2799)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2139)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2306)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at com.maipu.analyse.plugins.AbstractAnalyzer.excuteSelectSql(AbstractAnalyzer.java:303)

at com.maipu.analyse.plugins.userActionAnalyzer.UserActionAnalyzer.beginAnalyse(UserActionAnalyzer.java:160)

at com.maipu.analyse.service.AnalyzerRunTask.call(AnalyzerRunTask.java:93)

at com.maipu.analyse.service.AnalyzerRunTask.call(AnalyzerRunTask.java:31)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2016-03-17 02:30:15.844 INFO com.maipu.analyse.plugins.userActionAnalyzer.UserActionAnalyzer.beginAnalyse(UserActionAnalyzer.java:190) - <success read 0 row from logTable>

需要修改Linux系统最大文件数据：

cat /etc/security/limits.conf

* soft nofile 65535

* hard nofile 65535

需要修改Mysql最大文件数据限制：

open_files_limit=65535