Skip to content

Database size and clean-up

The Database tab shows how big your database is and which tables take the most space. Cron already removes old logs and ticket files every run; the tab lets you run that clean-up at once and give the freed space back. Only Super Administrators see it.

  1. Go to System → Settings → System and open the Database tab.
  2. Read the table list: Rows (about) is the database’s own estimate, Free space is space left by deleted rows.
  3. Select Run clean-up now to delete what the retention settings would delete on the next cron runs: old activity, sign-in and email log entries, old API and email import log entries, and old ticket files (up to 500 files a run).
  4. Select Optimize tables to rebuild each table that has free space, one at a time, so the space goes back to the server. A big table can take a while and is briefly locked, so run it at a quiet time.

The Database tab with the database size, number of tables and free space, the Run clean-up now and Optimize tables buttons, and the table list.

The biggest tables come first, with their rows, size and free space.

How long each log is kept is set in System → Settings → Activity (see Choose log retention) and in the Support settings (Keep ticket files for, Keep the email import log for). Shorten a period first, then run the clean-up and optimize the tables.

Take a backup before you shorten a retention period: entries older than the new period are deleted for good.