Hi Justin, What is the log in via ssh ? Could you provide me some references ? Thank you. Br, Jerry Lin 2016-03-11 5:29 GMT+08:00 Justin Swanhart :

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 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 ha scritto:

Oggetto: Re: [Maria-discuss] The insert performance issue A: "Sergei Golubchik" Cc: maria-discuss@lists.launchpad.net 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 : 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@mariadb.org

-----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

_______________________________________________ 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