maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

If you log in via ssh there is no network latency per insert, the latency is to local host which is negligible.  Batch your inserts and you will see improved performance.

Sent from my iPhone

> On Mar 10, 2016, at 7:52 AM, Federico Razzoli <federico_raz@xxxxxxxx> wrote:
> 
> That could be a problem if DNS is not reliable, but I never heard of a 10 seconds DNS request.
> I'd strongly recommend to assign more memory to the buffer pool. If InnoDB is the main storage engine you use, 1.5G should be ok.
> Swap is evil for a database, so you should make sure that loading a dump does not cause swapping.
> 
> Federico
> 
> 
> --------------------------------------------
> Gio 10/3/16, Jerry Lin <jerry08291021@xxxxxxxxx> ha scritto:
> 
> Oggetto: Re: [Maria-discuss] The insert performance issue
> A: "Sergei Golubchik" <serg@xxxxxxxxxxx>
> Cc: maria-discuss@xxxxxxxxxxxxxxxxxxx
> Data: Giovedì 10 marzo 2016, 11:20
> 
> Hi
> ,My MariaDB original setting has include
> "skip-name-resolve" .
> 2016-03-10 16:48
> GMT+08:00 Sergei Golubchik <serg@xxxxxxxxxxx>:
> Hi,
> 林澤宇!
> 
> 
> 
>> On Mar 10, 林澤宇 wrote:
>> 
>> 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 ?
> 
> 
> 
> May be hostname resolution? As far as I
> understand the default resolver
> 
> timeout is 5 seconds (man resolv.conf) - two failed name
> lookups gives
> 
> you exactly 10 seconds.
> 
> 
> 
> Try --skip-name-resolve on the remote mariadb server and
> make sure you
> 
> only use IP adresses when granting privileges and when
> connecting to the
> 
> server.
> 
> 
> 
> Regards,
> 
> Sergei
> 
> Chief Architect MariaDB
> 
> and security@xxxxxxxxxxx
> 
> 
> 
> -----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
> 
> _______________________________________________
> 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