为啥mysql的导出 out file 会卡住

ofwho 发布于 2013/07/27 19:10
阅读 302
收藏 0

为啥mysql的导出 out file 会卡住  求解答

/usr/local/mysql/bin/mysql -h '10.1.1.20' -u logsuser -p'^>PuwHME' -e "SELECT COUNT(*) AS total,fn FROM play_hash_1.1f WHERE fn !='' AND stream =3 AND server_time > '2013-07-13 00:00:00' AND server_time < '2013-07-14 00:00:00' GROUP BY fn  into outfile '/data1/dbback/play_hash_1.1f.txt' fields terminated by '^A' lines terminated by '\r\n'"

这个语句查询出1百万条数据,每次执行都导出数据到文件后,卡住,然后下面的循环都执行不了

加载中
0
北坡²º¹²
北坡²º¹²
mysql自己的机制,看下有没配置文件设置时间参数的
返回顶部
顶部