Database/Table optimization

When running the maintenance script "update.php" (MediaWiki.org) or maintenance script "setupStore.php"Allows to set up the data backend/store it is generally not recommended to disable the table optimization (see --skip-optimize option) in order to ensure that the query planner of the relational database management system (RDMBS) uses the most recent table statistics to make a best effort when selecting query paths.

Of course, if your wiki has a general maintenance window for activities like running table optimizations then it is recommended to postpone those tasks to the preferred time.

See also

• MySQL Understanding the Query Execution Plan
• PostgreSQL Planner/Optimizer
• SQLite Query Planning