← Back to team overview

maria-discuss team mailing list archive

Re: The insert performance issue


Am 10.03.2016 09:42, schrieb Sergei Golubchik:
> 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)")

I have no clue what the problem is i can only say in my context it is
faster to use ssh


Follow ups