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