maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Walter!

On Mar 10, walter harms wrote:
> Am 10.03.2016 04:52, schrieb 林澤宇:
> > 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 ?
> 
> I have notice that mariadb (and mysql) need a lot of time for login.
> A noteable speedup is to use ssh+keyexchange.

This is simply not true. MariaDB (and MySQL) authetication protocol is
very light-weight, the server sends the welcome packet, the client
replies with the username/password, the server sends "OK". It is
certainly much cheaper than SSH.

Either way, in the original question there is only one connection,
and authentication - even as slow as SSH - cannot take 10 seconds.

(unless he used a custom authentication plugin that does "sleep(10)")

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx