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 <greenl...@gmail.com>: > 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_...@yahoo.it> > 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 <jerry08291...@gmail.com> ha scritto: > > > > Oggetto: Re: [Maria-discuss] The insert performance issue > > A: "Sergei Golubchik" <s...@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 <s...@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 secur...@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 >
_______________________________________________ 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
