1 of 11 – MySQL – Instance Manager – Variables
2 of 11 – MySQL – Instance Manager – Status
3 of 11 – MySQL – Instance Manager – Charsets
4 of 11 – MySQL – Instance Manager – Collations
5 of 11 – MySQL – Instance Manager – Plugins
6 of 11 – MySQL – Storage Manager – Databases
7 of 11 – MySQL – Storage Manager – Engines
8 of 11 – MySQL – Storage Manager – Objects
9 of 11 – MySQL – Storage Manager – Open Tables
10 of 11 – MySQL – Security Manager – Tree
11 of 11 – MySQL – Session Manager – Sessions
MariaDB and MySQL
Database Administrator Tools
Aqua Data Studio offers a suite of MySQL and MariaDB Database Administration Tools for the monitoring, maintaining and tuning of the MySQL and MariaDB platforms. It includes an Instance Manager, Storage Manager, Security Manager and Session Manager. These managers allow the monitoring and maintenance of Database Objects, Sessions, Users and Permission via GUI.
Aqua Data Studio
Instance Manager
Provides GUI view Search and Edit access for:
- Instance Variables View and Edit (333 entries)
- Instance Status Parameters (301 entries)
- Character Sets Parameters
- Collations
- Plugins
Session Manager
Provides GUI view and Search access for:
- Session Details, Kill Session
Auto refresh data in specified intervals
Views for dynamically changed data such as Session Manager can be set for automatic refresh with intervals from 1 second and up.
Storage Manager
Provides GUI view Search and Modify access for:
- Database Properties, Create, Drop
- Engines Details with Engine Status and Mutex
- Objects Properties
- Tables Properties Open, Create, Alter, Drop
Security Manager
Provides GUI view Search and Modify access for:
- Tree view for Databases and Users
- Users View, Create, Alter, Drop
References
- ^ MySQL Database Wikipedia article. MySQL is an open source relational database management system (RDBMS), available under the terms of the GNU General Public License, owned by Oracle Corporation.
- ^ MariaDB Wikipedia article. MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system.