30 Aug
2016
30 Aug
'16
11:38 a.m.
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