maria-discuss team mailing list archive

[Jerry Lin <jerry08291021@xxxxxxxxx>]

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