[Maria-discuss] optimize table wait table level lock in MairaDB 10.1.16 ?
![](https://secure.gravatar.com/avatar/6aa4747f1a5db21d36e07cb9a825791e.jpg?s=120&d=mm&r=g)
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://secure.gravatar.com/avatar/79573204fb5075bc02698fb66dd194d4.jpg?s=120&d=mm&r=g)
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.
participants (2)
-
Daniel Black
-
Ljr Yang