Valerii Kravchuk added a comment - 2016-07-18 11:43 Basically, it seems MariaDB 10.1.x is affected by upstream https://bugs.mysql.com/bug.php?id=66237 . In one session (after creating table based on upstream test case and adding some rows there): 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) We see in different shell session: 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)