mysql大数据量导出运用ITeye - 众发娱乐

mysql大数据量导出运用ITeye

2019年02月23日11时50分27秒 | 作者: 寄风 | 标签: 企图,运用,成果 | 浏览: 992

昨日企图把wordlist表导到本地,仍运用mysql -e,成果等了半响mysql client 内存撑爆了。原因是mysql默许将一切数据都查询好后一次回来给客户端。
能够在-e前面加-q,这样虽然能解决问题,可是很慢。

摘自Mysql command-line tool文档:
If you have problems due to insufficient memory for large result sets, use the quick option. This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before displaying it. This is done by returning the result set using the mysql_use_result() C API function in the client/server library rather than mysql_store_result().

quick, -q

  Do not cache each query result, print each row as it is received. This may slow down the server if the output is suspended. With this option, mysql does not use the history file.
版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表众发娱乐立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章

阅读排行

  • 1

    oracle数据同步技能ITeye

    数据,技能,数据库
  • 2
  • 3

    mysql大数据量导出运用ITeye

    企图,运用,成果
  • 4
  • 5
  • 6
  • 7

    【备份】redis源码剖析ITeye

    调用,时分,个数
  • 8
  • 9

    sql2000 1433端口未翻开ITeye

    补丁,客户端,端口
  • 10

    JDBC衔接数据库众发娱乐

    数据库,句子,成果