About

The plugin provides tools for cleaning up database and simple SQL querying.

You can see the plugin enabled in Demo System.

Setup

Enable the plugin in server config.

dba:enable=1

# how many months old monthly or dropped by renaming tables and columns are proposed to be cleaned
#dba:clean.older.than.months=12

Usage

Database Cleanup

Database overview tool is available in menu Administration / DBA / Database. The tool allows to drop not more needed tables and columns, offered by the plugin. There are 22 tables and 3 columns on the screen below.

database

The drop candidates can be outdated monthly tables.

drop monthly tables

Or not more used tables and columns, named with underscore prefix. Note, that if there is a _yyyyMMdd name suffix exists, the entity can be dropped only after configured amount of months.

drop unused tables
drop unused columns

All the chosen entities can be dropped with the button under the table.

database drop button

With cleanup link right from DB state can be opened inconsistencies cleanup tool.

cleanup

Amount of rows going to be removed are shown in right column.

SQL Query

Is available in menu Administration / DBA / SQL Query

sql query

Provides simple querying. Also queries history is being maintained.