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