maria-discuss team mailing list archive

[Daniel Black <daniel.black@xxxxxxxxxxx>]

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.