maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #03409
R: The insert performance issue
林澤宇, there is clearly some difference between your servers.
Same version?
Same storage engine (InnoDB)?
Same indexes?
Memory is full, maybe swapping?
If all these things are ok, check your settings (SHOW VARIABLES).
Federico
--------------------------------------------
Gio 10/3/16, 林澤宇 <jerry08291021@xxxxxxxxx> ha scritto:
Oggetto: [Maria-discuss] The insert performance issue
A: maria-discuss@xxxxxxxxxxxxxxxxxxx
Data: Giovedì 10 marzo 2016, 04:52
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 ?
-----Segue allegato-----
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp