MySQL Administrator

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment.
Download

MySQL Administrator Ranking & Summary

Advertisement

  • Rating:
  • License:
  • GPL
  • Price:
  • FREE
  • Publisher Name:
  • MySQL AB.
  • Publisher web site:
  • http://www.mysql.com/

MySQL Administrator Tags


MySQL Administrator Description

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment. MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating.MySQL Administrator now integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.Here are some key features of "MySQL Administrator":· Achieve higher database availability through improved management· Reduce errors through visual database administration· Lower database administration costs through improved productivity· Deliver a more secure environment through easier privilege managementMySQL Administrator enables developers and DBAs to easily perform all the command line operations visually including configuring servers, administering users, and dynamically monitoring database health.Other common administrative tasks such as monitoring replication status, backup and restore, and viewing logs can also be performed through the MySQL Administrator graphical console.Here are some key features of "MySQL Administrator":User Administration in Minutes · Administering users, granting privileges and viewing user privilege information has never been easier! Now you can leverage the full power of MySQL's user management and privilege capabilities to fully protect your MySQL server host using an integrated graphical user administration console. For example, a form-based interface provides a simple method for adding users, assigning passwords and including user profile information. Plus, assigning and revoking global, database, and table/column privileges is as easy as adding and removing privilege items from an available list. Finally, an explorer interface provides a hierarchical view allowing you to easily view user privileges by privilege type. Single View Dynamic Health Monitoring · Dynamic health monitoring gives you an immediate view into the key indicators of the health of your MySQL environment. Dynamic graphs enable you to easily view percentage of memory usage, connection usage, hit rates, as well as the number of SQL queries on an ongoing basis, as your system runs. The Disk Health tab gives you an overview of the amount of hard disk space, tablespace, and log files being used. You can also use the visual health monitoring feature to get a hierarchical view into status and server variables such as the number of outstanding connections, number of Quickly Optimize MySQL · MySQL Administrator now allows you to easily view and setup key parameters so you can quickly optimize the performance of MySQL. Using a graphical forms-based environment, you quickly fine tune general and advanced parameters. For example you can set memory usage parameters and configure server start-up parameters related to the MyISAM and InnoDB table types. Rapid Disaster Prevention and Recovery · Now you can rapidly create consistent backups and restore data by simply visually selecting the schemas and tables you want to back/restore from your hierarchical data directory. The graphical environment gives you additional visibility into Tabletype, Rows, Data Length, and Update time. Server Information At-a-Glance · The server information section of MySQL Administrator allows you to quickly view basic information about the server and client. This view gives you immediate visibility into items such as server status, client and server version numbers and IP address, as well as connection information. View Replication Status · Now you can quickly set up replication to increase the robustness and speed of your MySQL environment. The replication features within MySQL Administrator allow you to easily view the network topology of your replication master and slaves. Plus, the graphical environment provides additional visibility into IP addresses and logfiles. Service Control · Gain complete control of service creation and overcome the time consuming task of installing and setting up services. Plus, start and stop MySQL servers and view corresponding log messages. Browse Catalog · Browse your catalog and view corresponding tables with columns, all indices and users with privileges to access selected databases. From here you can monitor and optimize tables.What's New in This Release:· Assorted major updates and bugfixes.


MySQL Administrator Related Software