MySQL Optimizer (was MySQL and MariaDB Optimizer) is an effective app that gives you recommendations for optimization of MySQL databases. The app provides a graphical interface to simplify the process of viewing performance metrics, apply changes based on our recommendations, and all MySQL slow-query logs, which are grouped by occurrence number.
- Mysql Admin Tool For Windows
- Mysql Client Tool
- Mysql Administrator Tool
- Sql Query Tool For Mac
- Mysql Database Manager Mac
Mysql Admin Tool For Windows
Things to consider when applying recommendations:
Mysql Client Tool
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases. MySQL Cluster CGE (commercial) MySQL Cluster is a real-time open source transactional database designed for fast, always-on access to data under high throughput conditions.
- MySQL GUI Tools 5.0r12 - Administration tools for MySQL. Download the latest versions of the best Mac apps at safe and trusted MacUpdate Download, install, or update MySQL GUI Tools for Mac from MacUpdate.
- EMS SQL Query for MySQL is a useful tool that lets you quickly and simply build SQL queries to MySQL databases. Visual MySQL query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to MySQL databases, select tables and fields for a query.
- When you apply changes MySQL service restarts so your web sites will be offline for couple seconds
- Make sure you understand the changes you make as in some cases they might not be suitable
- You can always revert changes by going to Backup/restore tab and select the version you want to revert to
- Once you apply some changes MySQL needs time to collect data again for new statistics and recommendations and while it's recommended to wait 24hours before applying more changes, the app will allow you to do it after 6hours
Features
- Performance Metrics (very useful info about your server and mysql)
- Slow Query that are already grouped so you can fix slow queries that have highest occurrence first.
- Option to Explain slow queries
- Error logs are available within Slow query main screen
- Recommendations tab is the app main function, where you see a list of issues and recommendations, where applicable you can set the value and just tick to apply new values.
- Mysql Advanced Variables Editor, so you can adjust MySQL even further
Mysql Administrator Tool
Multiple Database Query Analyzer 2.1 supports qurries with diffrent types of databases. It supports Sql, Access, Oracle, MySql.
- multidbqa.exe
- Vsisoftware.com
- Shareware ($29.95)
- 8.99 Mb
- Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000
Extract database schemas, build and run SQL queries, visualize data relationships in your databases, all with a single software package. Aglowsoft SQL Query Tools includes three database tools. They are Aglowsoft Schema Tool, Aglowsoft Designer, and Aglowsoft Browser.
- ags_qtools_v88.exe
- Aglowsoft
- Shareware ($88.00)
- 48.22 Mb
- Win2000, WinXP, Win7 x32, Win7 x64, Windows 8, Windows 10, WinServer, WinOther, WinVista, WinVista x64
Advanced DatabaseQuery is a relational database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft SQL Server and MySQL databases. Resultsets returned by select queries are automatically persisted to CSV.
- AdvancedDbQuery.msi
- Advanced Reliable Software,Inc.
- Shareware ($9.95)
- 404 Kb
- WinXP, Windows2000, Windows2003, Windows Vista, Win98, WinME, WinNT 3.x, WinNT 4.x
This project is a 3-tier DatabaseQuery Tool to written in java. The GUI client presents the user with an interface to enter text SQL Queries and view the results. The query server relays requests to the database and formats the response.
- jqueryserver-0.1.1.tar.gz
- Bob Loihl
- Freeware (Free)
- 30 Kb
- Windows; Mac; Linux
Automates execution of SQL (Structured Query Language) statements on Microsoft SQL Server and MySQL databases. Advanced Database Query Automaton is a scriptable relational database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft SQL Server and MySQL databases. Resultsets returned by select statements are automatically persisted to CSV spreadsheets.
- AdvancedDbQueryAutomaton.msi
- Advanced Reliable Software,Inc.
- Shareware ($9.95)
- 391 Kb
- WinXP, Windows2000, Windows2003, Windows Vista, Win98, WinME, WinNT 3.x, WinNT 4.x
The JUMP DB Query Plugin is an extension for the OpenJUMP GIS platform that allows OpenJUMP users to give arbitrary database queries to retrieve and display geographic feature. ...
- jumpdbplugin-0.8.0.zip
- jumpdbqplugin
- Freeware (Free)
- 485 Kb
- Windows; Mac; Linux
xmldbtools propose a serie of tools to manage and analysis asynchronous and heterogeneous time stamped data stored in a native xml database..
- xml database analysis tools
- Dweezil
- Freeware (Free)
- Windows
XWDB is an XML database integration toolkit for XML, relational, andgraph databases. The toolkit includes an XML adaptor forRDBMSs, a graph/XML data store implemented using aRDBMS, and tools for browsing and querying federated databases..
- xmldb_1-2-1.jar
- mgraves
- Freeware (Free)
- 460 Kb
- Linux
PgQuery is an interactive GUI tool for querying PostgreSQL databases. After connecting to a database server you can open views and tables, send custom sql statements, export the result to CSV (local file) or send it to KSpread to open it as a. ...
- pgqrysrc-de-0.0.1.tar.gz
- pgquery
- Freeware (Free)
- 248 Kb
- BSD; Linux
This project is to develop a set of software modules to be used to develop a Mammalian Promtoer Database system. Such databases contain information about the gene regulatory region annotation data. ...
- Mammalian Promter DatabaseQuery Tool
- Hao Sun
- Freeware (Free)
- Windows
DTM Query Reporter is a reporting tool for databasequery. The program creates reports in RTF, XML, HTML, PDF, CHM (Windows HTML Help), Excel or plain text formats and supports all common database interfaces - ODBC, OLE DB, IDAPI or OCI.
- qr_d.exe
- DTM soft
- Demo ($99.00)
- 1.37 Mb
- WinXP, WinVista, Win7 x32, Windows2000, Windows2003, WinServer, Windows Vista, Windows Media Center Edition 2005
Database recovery tools to perform SQL database recovery, SharePoint database recovery & Access database recovery. Now you can easily recover and repair corrupt SQL database that became corrupted due to any reason. SysTools makes possible and easier than ever to recover and fix corrupt or inaccessible SQL database, Database Recovery software is a perfect and right solution to repair corrupt SQL server database quickly.
- systools-sql-recovery.exe
- Database Recovery
- Shareware ($129.00)
- 1.81 Mb
- WinXP, Win2000, Win Vista, Win98, Windows 7
Related: