MariaDB [test]> analyze insert into t1 values (1),(2);

Query OK, 2 rows affected (0.07 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> explain insert into t1 values (1),(2);

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

| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | Extra |

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

|    1 | INSERT      | t1    | ALL  | NULL          | NULL | NULL    | NULL | NULL | NULL  |

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

1 row in set (0.00 sec)

MariaDB [test]> analyze replace into t1 values (1),(2);

Query OK, 2 rows affected (0.05 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> explain replace into t1 values (1),(2);

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

| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | Extra |

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

|    1 | INSERT      | t1    | ALL  | NULL          | NULL | NULL    | NULL | NULL | NULL  |

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

1 row in set (0.00 sec)

Branch: 10.1

commit b95ec135533b13e921aa8de1b9c769d47b2efe60

Author: Alexey Botchkov <holyfoot@montyprogram.com>

Date:   Thu Jun 26 11:37:24 2014 +0500