maria-discuss team mailing list archive
Mailing list archive
Re: optimize table wait table level lock in MairaDB 10.1.16 ?
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-
https://jira.mariadb.org/browse/MDEV-7901 was recently implemented for
I suggest raising a JIRA task for this too with a good use case for