11-04-2012, 03:25 PM
MySQL Administrator
administrator-en.a4.pdf (Size: 805.55 KB / Downloads: 233)
MySQL Enterprise
A MySQL Enterprise subscription is the most comprehensive offering of MySQL database software, services and support; it ensures
that your business achieves the highest levels of reliability, security, and uptime.
An Enterprise Subscription includes:
1. The MySQL Enterprise Server – the most reliable, secure, and up-to-date version of the world’s most popular open source
database
2. The MySQL Enterprise Monitor – An automated virtual DBA assistant that monitors all your MySQL Servers aroundthe-
clock, identifies exceptions to MySQL best practices, and provides expert advice on fixing any problems discovered
3. MySQL Production Support – Technical and consultative support when you need it, along with regularly scheduled service
packs, hot-fixes, and more
Introduction to MySQL Administrator
MySQL Administrator is a program for performing administrative operations, such as configuring, monitoring and starting and
stopping a MySQL server, managing users and connections, performing backups, and a number of other administrative tasks.
Most tasks can be performed using a command-line client such as mysqladmin, or mysql, but MySQL Administrator has the
following advantages:
• Its graphical user interface makes it more intuitive.
• It provides a better overview of the settings that are crucial for the performance, reliability, and security of your MySQL servers.
• It displays performance indicators graphically, thus making it easier to determine and tune server settings.
Installing Under Windows
MySQL GUI Tools run on recent 32-bit Windows NT based operating systems, including Windows 2000, XP, Vista, and 2003.
They don't run on Windows NT 4 and below.
Using the Windows Installer
MySQL GUI Tools can be installed on all Windows operating systems using the Windows Installer (.msi) installation package.
The MSI package is contained within a ZIP archive named mysql-gui-tools-version-win32.msi, where version indicates
the MySQL GUI Tools version.
The Microsoft Windows Installer Engine was updated with the release of Windows XP; those using a previous version of Windows
can reference this Microsoft Knowledge Base article for information on upgrading to the latest version of the Windows Installer
Engine.
Installing From the ZIP File
If you are having problems running the installer, as an alternative, you can download a ZIP file without an installer. That file is
called mysql-gui-tools-noinstall-version-win32.zip. Using a ZIP program, unpack it to the directory of your
choice. You may also want to create shortcuts to MySQLAdministrator.exe, MySQLMigrationTool.exe, and
MySQLQueryBrowser.exe for your desktop or the quick launch bar.
Installing Under Linux
MySQL GUI Tools runs on Linux machines that have a graphical desktop installed. It is designed to run under the Gnome desktop
with GTK2 and has been tested on Linux kernel versions 2.4 and 2.6. It should also run on other versions, and even on a number of
Unix-like operating systems.
Appendix F. XML Files Used by MySQL Administrator
Besides the documentation you are currently reading (which is written in DocBook XML), MySQL Administrator uses a number of
XML files for internal purposes.
• mysqlx-options.xml: Stores options selected in the Options dialog.
• mysqlx-status-variables.xml: Stores the status variables known to
MySQL Administrator, so that they can be assigned
descriptions in various languages (see below for the XML file containing those descriptions). Those descriptions will
show up in the Status Variables tab of the Health section. You can select the language of the descriptions in the General Options
section of the Options dialog. That file also determines in which categories or subcategories a variable will appear, and the
order in which categories and subcategories appear. However, it does not determine the order of variables within a category or
subcategory, as these are sorted lexically by MySQL Administrator.