On 30/08/16 19:38, Ljr Yang wrote:

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

https://jira.mariadb.org/browse/MDEV-7901 was recently implemented for analyze tables.

I suggest raising a JIRA task for this too with a good use case for doing this.