maria-discuss team mailing list archive
Mailing list archive
The insert performance issue
Hi ALL ,
I test the MariaDB performance of insert command .
I use a file include 100000 insert command statements to test the insert
On local server ,the Mariadb spent about 20 second to insert data;but on
remote server ,the MariaDB spent about 30 second to insert data .
I execute the command " mysql -h db1 -utest -ptest -D IST <
insert_file.sql" on local and remote servers .
Why the MariaDB has about 10 second gap ?
Maybe the network should to cause some latancy ,but the time should not
have so long .
What issue to cause the gap ?