发布时间:2011-08-24 20:14:30
MySQL 的默认设置下,当一个连接的空闲时间超过8小时后,MySQL 就会断开该连接,而 c3p0 连接池则以为该被断开的连接依然有效。在这种情况下,如果客户端代码向 c3p0 连接池请求连接的话,连接池就会把已经失效的连接返回给客户端,客户端在使用该失效连接的时候即抛出异常。这就是传说中.........【阅读全文】
发布时间:2011-08-24 19:58:41
Repair MySQL ReplicationMy SQL 复制过程中,sql post thread如果执行某个SQL出错,则会自动停止并且在日志和show slave status中提示错误信息。错误日志如下:110824 19:11:02 [ERROR] Slave SQL: Could not execute Delete_rows event on table smarteye.client_reqs; Can't find record in 'client_reqs'.........【阅读全文】
发布时间:2011-08-22 15:14:36
Mysql意外关闭导致网页报错We're sorry, but something went wrong.We've been notified about this issue and we'll take a look at it shortly.登录上服务器发现mysql已关闭,重启mysqld服务失败查看mysql日志,如下110822 13:02:34 mysql.........【阅读全文】