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
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
