maria-discuss team mailing list archive

[Ljr Yang <dbmsprog@xxxxxxxxx>]

Hi, all
   Today,   we use optimize table in MariaDB 10.1.16.
    Table test01 have about 2 millions records.


session 1:  optimize table test01;

session 2:  select count(*) from test01 ;

when session 1 run,   In processlist session 2 state:  Waiting FOR TABLE
LEVEL LOCK

    we had set innodb_defragment=1 in my.cnf ,but run optimize table still
have table lock？

reference link:
https://mariadb.com/kb/en/mariadb/defragmenting-innodb-tablespaces/


-- 
Ljr