3
mysqldump 参数 net-buffer-length
source link: https://abcdxyzk.github.io/blog/2023/12/10/mysqldump-len/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
mysqldump 参数 net-buffer-length
2023-12-10 16:43:00
https://blog.csdn.net/yexiaomodemo/article/details/111050882
比如设置成 –net-buffer-length=10m ,那么一旦你使用到还原时,你的数据一次commit提交是默认1m 提交时的10倍速度
比如设置成 –net-buffer-length=10m ,小表估计就是一个insert就完事了,导入时效率会很高。当你备份文件有5G 10G了,那个时候这些参数非常有用
Posted by kk
2023-12-10 16:43:00tools, mysql
« Ubuntu安装vulkan PHP数组实际占用内存大小的分析 »
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK