optimizeTables

Description

Optimizes all tables in the database and lists how much was saved.

Syntax

void optimizeTables ()


Notes

  • Requires the admin_forum permission.
  • Uses the rawdata sub template (built in.)
  • Shows as the maintain_forum admin area.
  • Updates the autoOptLastOpt setting such that the tables are not automatically optimized again too soon.
  • Accessed from ?action=optimizetables.

Context ($context) Variables
Name Description
$context['num_optimized_tables'] How many tables were optimized
$context['num_tables'] The number of tables in your database
$context['optimized_tables'] An array of tables that were optimized (numeric keys). Each entry has 'name' (table name) and 'data_freed' (how much was optimized)
Advertisement: