maria-discuss team mailing list archive
Mailing list archive
Re: The insert performance issue
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 :
2016-03-10 16:58 GMT+08:00 Federico Razzoli <federico_raz@xxxxxxxx>:
> 林澤宇, 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
> 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