Shulou(Shulou.com)06/01 Report--

For the myisam table, lock table table_name read local, and the following parameters are 2, 3, then another reply is allowed to execute the insert statement

Root@sakila 08:17:02 > show variables like'% concurrent%'

+-+ +

| | Variable_name | Value |

+-+ +

| | concurrent_insert | ALWAYS |

+-+ +

1 row in set (0.01 sec)

Root@sakila 08:19:29 > lock table myfilm_text read local

Query OK, 0 rows affected (0.01 sec)

Insert cannot be executed in the same session because you are on a read-only lock

Root@sakila 08:19:37 > insert into myfilm_text (film_id, title) values (1002, 'Test')

ERROR 1099 (HY000): Table 'myfilm_text' was locked with a READ lock and can't be updated

*

Another session:

Can be inserted concurrently, in turn can achieve a certain degree of concurrency.

Root@sakila 08:18:32 > insert into myfilm_text (film_id, title) values (1002, 'Test')

Query OK, 1 row affected (0.02 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.