Linux最大连接数问题

在运行程序并频繁进行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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值