MariaDB [test]> create or replace table t1 (a varchar(255));

Query OK, 0 rows affected (1.13 sec)

mysql  Ver 15.1 Distrib 10.1.8-MariaDB, for Linux (x86_64) using readline 5.1

MariaDB [test]> insert into t1 select seq_1_to_2000000;

ERROR 1054 (42S22): Unknown column 'seq_1_to_2000000' in 'field list'

MariaDB [test]> insert into t1 select * from seq_1_to_2000000;

^CCtrl-C -- sorry, cannot connect to server to kill query, giving up ...

Aborted

$ /data/releases/mariadb-10.1.8-linux-x86_64/bin/mysql -uroot --protocol=tcp  test --local-infile --port=3306 

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 4

Server version: 10.1.9-MariaDB Source distribution

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

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

MariaDB [test]> insert into t1 select * from seq_1_to_2000000;

^CCtrl-C -- sorry, cannot connect to server to kill query, giving up ...

Aborted

$ /data/releases/mariadb-10.1.8-linux-x86_64/bin/mysql -uroot --protocol=tcp  test --local-infile --port=3306 

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 5

Server version: 10.1.9-MariaDB Source distribution

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

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

MariaDB [test]> show processlist;

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

| Id | User | Host            | db   | Command | Time | State        | Info                                          | Progress |

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

|  3 | root | localhost:45321 | test | Query   |    9 | Sending data | insert into t1 select * from seq_1_to_2000000 |    0.000 |

|  4 | root | localhost:45322 | test | Query   |    5 | Sending data | insert into t1 select * from seq_1_to_2000000 |    0.000 |

|  5 | root | localhost:45323 | test | Query   |    0 | init         | show processlist                              |    0.000 |

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

3 rows in set (0.01 sec)

/data/releases/mysql-5.7.8-rc-linux-glibc2.5-x86_64/bin/mysql  Ver 14.14 Distrib 5.7.8-rc, for linux-glibc2.5 (x86_64) using  EditLine wrapper

mysql> insert into t1 select * from seq_1_to_2000000;

^C^C -- query aborted

ERROR 1317 (70100): Query execution was interrupted

mysql> insert into t1 select * from seq_1_to_2000000;

^C^C -- query aborted

ERROR 1317 (70100): Query execution was interrupted

mysql> show processlist;

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

| Id | User | Host            | db   | Command | Time | State        | Info                                          | Progress |

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

|  3 | root | localhost:45321 | test | Query   |   32 | Sending data | insert into t1 select * from seq_1_to_2000000 |    0.000 |

|  4 | root | localhost:45322 | test | Query   |   27 | Sending data | insert into t1 select * from seq_1_to_2000000 |    0.000 |

|  6 | root | localhost:45324 | test | Query   |    0 | init         | show processlist                              |    0.000 |

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

3 rows in set (0.00 sec)