| Back to logs list
3215865 2010 年 07 月 22 日 00:58 Reading (loading. ..) Comments (0) Category: MySQL
MySQL export import SQL statements may be very,
louboutin uk, very slowly,
christian louboutin slingbacks, and experienced only 45 million records to import,
louboutin shoes, actually took almost 3 hours. When you export the rational use of several parameters,
louboutin shoes sale, you can greatly speed up the rate of import.
-e include several VALUES lists to use multi-line INSERT syntax;
max_allowed_packet = XXX client / server communication between the maximum buffer size;
net_buffer_length = XXX TCP / IP and socket communication buffer size,
christian louboutin pumps, create the length of the line net_buffer_length.
Note: max_allowed_packet and net_buffer_length can not set the value than the target database, large, or may be wrong.
first determine the objectives of the library
parameters
mysql> show variables like 'max_allowed_packet';
mysql> show variables like 'net_buffer_length';
write mysqldump command under the parameter values,
christian louboutin discount, such as:
max_allowed_packet and net_buffer_length front are two -
the previous 2 hours to import the sql are now tens of seconds to be completed.