MariaDB [hello]> show create table a;

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

| Table | Create Table                                                                                                                           |

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

| a     | CREATE TABLE `a` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  UNIQUE KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 |

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

1 row in set (0.00 sec)

MariaDB [hello]> lock table a write;

Query OK, 0 rows affected (0.00 sec)

MariaDB [hello]> 

[2]+  Stopped                 mysql

[root@galera1 my.cnf.d]# fg 1

mysql

MariaDB [hello]> insert into a values(null);

^Z

[1]+  Stopped                 mysql

[root@galera1 my.cnf.d]# fg 2

mysql

MariaDB [hello]> unlock tables;

Query OK, 0 rows affected (0.00 sec)

MariaDB [hello]> show global status like 'table_lock%';

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

| Variable_name         | Value |

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

| Table_locks_immediate | 26    |

| Table_locks_waited    | 0     |

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

2 rows in set (0.00 sec)

MariaDB [hello]> 

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