问题描述:
首先是在执行一个脚本的时候(mysql < query.sql),中间会出现Lost connection during query的错误提示,但是错误日志里面没有记录。一开始想到是不是mysql时间相关的配置有问题,检查一下与时间相关的参数,基本上都很大,时间相关的参数这里就不赘述了。那么是什么问题导致的呢,没有日志,只有这个dt的错误。之后在相同的环境下测试了一个创建临时表的语句,哎,突然出现了错误,create temporary table tmp(id int) engine=InnoDB;会报错;
2013-11-07 16:54:02 8013 [ERROR] InnoDB:Failed to set O_DIRECT on file /tmp/#sql1f4d_f_0.ibd: CREATE: Invalid argument,continuing anyway
2013-11-07 16:54:02 8013 [ERROR] InnoDB:O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQLBug#26662
2013-11-07 16:54:02 8013 [ERROR] InnoDB:Failed to set O_DIRECT on file /tmp/#sql1f4d_f_0.ibd: OPEN: Invalid argument,continuing anyway
2013-11-07 16:54:02 8013 [ERROR] InnoDB:O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQLBug#26662
之后查看 bug 2