When running the update.php or setupStore.php script it is generally not recommended to disable the table optimization (see --skip-optimize option) in order to ensure that the RDMBS query planner 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.
