MIDAS includes a number of handy “Database Tools“.

These tools help system administrators keep their MIDAS systems running efficiently.

The “Cleanup” tools allow for the quick removal of obsolete data within a MIDAS booking system.

Separate tools are provided for removing outdated bookings, invoices, clients, and users respectively.

There’s also an “Optimize Database” tool which runs a series of commands on the underlaying MySQL / MariaDB database to help it run more efficiently.

For v4.36, we’ve added a new “One-Stop Cleanup” tool to the list of cleanup tools. This new tool provides a fast way to collectively run several other cleanup tools.

The actions the new One-Stop Cleanup tool performs are:

  • Performing a “One-Stop Cleanup” will, in a single action:
  • Remove bookings that occurred more 5 years ago.
  • Remove invoices that were paid more than 5 years ago.
  • Remove clients with no bookings in the past 2 years.
  • Remove users who have not logged in for more than 1 year.
  • Optimize the database.

Whilst there are no limits imposed in our software for how long data should persist, without using the Database Cleanup tools, data will persist indefinitely.

An organization may have a requirement for client and invoice data to be kept for a specific period of time, but it’s unlikely that most organizations will need to keep such information indefinitely.

This is where the cleanup tools in MIDAS become useful.

Performing routine cleanups of very old and obsolete data in your MIDAS help keep your system running efficiently.

Database Tools in MIDAS
Database Tools in MIDAS