openxs@ao756:~/dbs/maria10.1$ bin/mysql --no-defaults -uroot test               Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 6

Server version: 10.1.15-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [test]> load data infile '/home/openxs/dump.txt' into table t;

Query OK, 131072 rows affected (1.76 sec)

Records: 131072  Deleted: 0  Skipped: 0  Warnings: 0

MariaDB [test]> select @@autocommit, @@binlog_format, @@binlog_cache_size;

+--------------+-----------------+---------------------+

| @@autocommit | @@binlog_format | @@binlog_cache_size |

+--------------+-----------------+---------------------+

|            1 | ROW             |               32768 |

+--------------+-----------------+---------------------+

1 row in set (0.00 sec)

openxs@ao756:~$ ps aux | grep mysqld

openxs    3859  0.0  0.0   4440   772 pts/4    S    13:41   0:00 /bin/sh bin/mysqld_safe --no-defaults --log-bin --binlog-format=ROW

openxs    3932  0.2  3.2 751820 125820 pts/4   Sl   13:41   0:08 /home/openxs/dbs/maria10.1/bin/mysqld --no-defaults --basedir=/home/openxs/dbs/maria10.1 --datadir=/home/openxs/dbs/maria10.1/data --plugin-dir=/home/openxs/dbs/maria10.1/lib/plugin --log-bin --binlog-format=ROW --log-error=/home/openxs/dbs/maria10.1/data/ao756.err --pid-file=ao756.pid

openxs    4307  0.0  0.0  14636   968 pts/10   S+   14:40   0:00 grep --color=auto mysqld

openxs@ao756:~$ ls -l /proc/3932/fd | grep deleted

lrwx------ 1 openxs openxs 64 лип 18 13:43 12 -> /tmp/ibMBcC19 (deleted)

lrwx------ 1 openxs openxs 64 лип 18 13:43 5 -> /tmp/ibYbf26G (deleted)

lrwx------ 1 openxs openxs 64 лип 18 14:30 51 -> /tmp/ML7SRS6f (deleted)

lrwx------ 1 openxs openxs 64 лип 18 13:43 6 -> /tmp/ib11pw1n (deleted)

lrwx------ 1 openxs openxs 64 лип 18 13:43 7 -> /tmp/iboNL0V4 (deleted)

lrwx------ 1 openxs openxs 64 лип 18 13:43 8 -> /tmp/ib4EEYNs (deleted)

openxs@ao756:~$ lsof | grep  /tmp/ML7SRS6f | head -1

mysqld    3932          openxs   51u      REG              252,1   2427231 17563681 /tmp/ML7SRS6f (deleted)