Hi ,
The two MariaDB are the same version  and using InnoDB engine .
The table of insert has no any key or index .
My server has 2G memory and 128M for innodb_buffer_pool_size .

I use top to monitor the memory usage ,swap has be used a little ,but also has free physical memory space . 

I upload my variables file as below link :
http://www.2shared.com/document/e-xJMVO4/variables.html

Thank you.

Jerry Lin
2016-03-10 16:58 GMT+08:00 Federico Razzoli <federico_raz@yahoo.it>:
林澤宇, 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@gmail.com> ha scritto:

 Oggetto: [Maria-discuss] The insert performance issue
 A: maria-discuss@lists.launchpad.net
 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@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp