← Back to team overview

maria-discuss team mailing list archive

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).


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
 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

Follow ups