maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #03419
Re: The insert performance issue
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 <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
>
References