Linux最大连接数问题

程序在大量进行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