mariadb db settings for insert speed code example

Example: mariadb insert 10000 rows in one query

INSERT INTO table_name values(1,"row 1"),(2, "row 2"),...;