maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #03405
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
performanc .
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 ?
Follow ups