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 tables are proposed to be dropped, default is 12
#dba:cleanup.month.tables.older.than.months=12

Usage

Database Cleanup

Database overview tool is available in menu Administration / DBA / Database.

database

Underscore prefixed temporary tables same as old monthly tables may be selected and dropped with button under the table.

database drop

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.