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@gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] The insert performance issue A: "Sergei Golubchik" <serg@mariadb.org> 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 <serg@mariadb.org>: 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