One time with friends to discuss the net-buffer-length may have an impact on the mysqldump export and recovery, test it, found that the impact is very small, the basic can be neglected, the following is the comparison test results.
Description: When executing mysqldump, the maximum limit for net buffer length is 16Mb, the default value is 1Mb, and the following is the test result map:
650) this.width=650; "Src=" Http://dp.imysql.com:8080/files/upload_yejr_imysql/2012-06-20_net_buffer_length%E5%AF %b9%e5%a4%87%e4%bb%bd%e5%8f%8a%e6%81%a2%e5%a4%8d%e7%9a%84%e5%bd%b1%e5%93%8d.png "title=" 2012-06-20_net_buffer_ The effect of length on backup and recovery. png "style=" border:0px; "alt=" 2012-06-20_net_buffer_length%e5%af%b9%e5 "/>
As can be seen from the comparison above, the adjustment of this option has little effect on the time required for the export, only has a certain effect on the export file, but it is also small; Similarly, the impact on data recovery is minimal.
--------------------------------------Split Line--------------------------------------
http://zhishuedu.comTraining is a professional quality training brand jointly launched by senior MySQL expert Ye Jinlong and Wu Bingxi, with MySQL dba combat optimization and Python devops Development course, which is the most conscientious and The most quality training courses.
This article is from the "Lao Ye teahouse" blog, please be sure to keep this source http://imysql.blog.51cto.com/1540006/1879735
FAQ Series | Impact of net_buffer_length options on data backup and recovery