2 qq512145547 qq512145547 于 2016.03.19 13:00 提问

MySql每天在同一个时间点报错:Timeout expired. 20C

连接:局域网内连接;
Mysql安装方式:以Windows服务的方式启动,mysqld install 服务名,配置文件只有一个my.ini文件;
数据库访问方式:调用程序集MySql.Data.dll,版本5.0.9.0;
程序:定时每分钟往局域网内的服务器插入数据,分实时数据和历史数据;
历史数据:每分钟统计好所有数据,一次性以“insert 表名 Value(),()....”的方式插入;
实时数据:每分钟等历史数据插完,以循环方式插入每条数据,循环中数据库连接每次都Open和Close;
出错:每天都在中午11:55分插入实时数据时报错“**imeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.**”而且每天报错时插入的数据都时同一条;
采取措施:已经在ini配置文件中加入配置interactive_timeout=604800;wait_timeout=604800。
但是问题一直得不到解决,希望有人能帮我分析下问题到底出现在哪里;

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!
其他相关推荐
【数据库-MySql】 MySqlConnection error connecting: Timeout expired. (1)
error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was r
ASP.NET连接 MS SQL Timeout expired. 问题的处理
    今天在项目中遇到一个Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding 的SQL执行超时异常,在网上google了一下,大家都遇到过我种情况,我还是第一次遇到,影响服务器产生超时的设置大致有: 1. Serve
mysql连接池和 "Timeout expired"异常
异常信息: MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because
MySql 长时间读数据发生超时的异常 Mysql Reader Exception TimeOut expired
1. 写ConnectString: Server=abc;UserId={1};Password={2};Database={3};Allow User Variables={4};Pooling=true;Connect Timeout={5};default command timeout={6}"
mysql Timeout expired
问题: A3区) 2012-11-21 14:30:25 Action.c(90):     [Exception]: error connecting: Timeout expired.  The timeout period elapsed prior to obtai Action.c(90):     ning a connection from the pool.  This ma
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
今天碰到了一个查询异常问题,上网查了一下,感谢原创和译者如果你使用的数据库连接类是 the Data Access Application Blocks "SqlHelper" 或者 SqlClient Class , 你在执行一个很费时的SQL 操作时候,可能就会碰到下面的超时异常。---------------------------------------------------
Timeout expired , The timeout period elapsed prior to completion of the operation or the server
在使用SqlHelper时出现此问题,解决方法是对设置SqlCommand的Timeout,注意不是SqlConnection的Timeout。相关代码如下 private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType,
【secureCRT ssh error】The semaphore timeout period has expired
问题: secureCRT登录linux服务器后,过几分钟不操作,出现下面提示后,便无法: 方法:     $sudo -s     #vim /etc/ssh/sshd_config     GG到文件末尾,增加下面一行:     ClientAliveInterval 60     #reboot,然后就解决问题了。 (end)
.Net 连接池的配置Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”
.Net 连接池的配置Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”ADO.Net 在数据库操作过程中默认打开了连接池,不需要再进行手工配置。这个特性可以使数据库操作时效率提高,但也要有相应的代码配合,才能
WebService调度超时
给客户开发了一个webService接口,在调用超时,提示:Server was unable to process request. ---> Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because a