[MDEV-19890] ANALYZE documentation Created: 2019-06-27  Updated: 2019-07-08  Resolved: 2019-07-08

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.4
Fix Version/s: N/A

Type: Bug Priority: Trivial
Reporter: VAROQUI Stephane Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-6521 HELP Contents need to use MariaDB Kno... Closed

 Description   

Hi,

  • HELP ANALYZE TABLE
  • KB ANALYZE TABLE
    Don't talks about PERSISTENT keyword but EITS became default in 10.4


 Comments   
Comment by Ian Gilfillan [ 2019-07-01 ]

HELP is part of by MDEV-6521, which will be automatically generated from the KB. For the second part, are you talking about the page https://mariadb.com/kb/en/library/analyze-table/? This needs updating, but does mention the PERSISTENT keyword. If there's another page, please link it here.

Comment by VAROQUI Stephane [ 2019-07-01 ]

Hi Ian i open that issue during the pick hit in europe , may be i miss read the KB or may be google point to some old page , please apology for wrong reporting looks like KB is indeed correct

Comment by VAROQUI Stephane [ 2019-07-01 ]

At the same time i think review is needed : "For InnoDB the table is locked with a write lock." this statement need to be refresh to relate the last status of innodb locking on analyze , i was told this was changed long time ago to be non locking, if still locking spending so much effort on instant DDL operation and keeping an analyze under lock would be very sad !

Generated at Thu Feb 08 08:55:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.