Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 31.4Mb
PDF (A4) - 31.4Mb
PDF (RPM) - 29.8Mb
HTML Download (TGZ) - 7.5Mb
HTML Download (Zip) - 7.5Mb
HTML Download (RPM) - 6.4Mb
Man Pages (TGZ) - 177.2Kb
Man Pages (Zip) - 287.5Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb
Excerpts from this Manual

2.3.4.1 MySQL Notifier Usage

MySQL Notifier provides visual status information for the MySQL servers that are monitored on both local or remote computers. The MySQL Notifier icon in the taskbar changes color to indicate the current status: Running or Stopped.

MySQL Notifier automatically adds discovered MySQL services on the local computer. By default, the Automatically add new services whose name contains option is enabled and set to mysql. Related notification options include being notified when new services are either discovered or experience status changes, and are also enabled by default. Uninstalling a service removes the service from MySQL Notifier.

Clicking the MySQL Notifier icon from the Windows taskbar reveals the MySQL Notifier main menu, which lists each MySQL server separately and displays its current status. You can start, stop, or restart each MySQL server from the menu as the following figure shows. When MySQL Workbench is installed locally, the Manage Instance and SQL Editor menu items start the application.

Figure 2.14 MySQL Notifier Service Instance Menu

Content is described in the surrounding text.

The Actions menu includes the following items:

  • Manage Monitored Items

  • Launch MySQL Installer (Only when the product is installed.)

  • Check for Updates (Only when MySQL Installer is installed.)

  • MySQL Utilities Shell (Only when the product is installed.)

  • Refresh Status

  • Options

  • About

  • Close MySQL Notifier

The main menu does not show the Actions menu when there are no services being monitored by MySQL Notifier.

MySQL Notifier Options

The Actions, Options menu provides a set of options that configure MySQL Notifier operations. Options are grouped into the following categories: General Options, Notification Options, and MySQL Server Connections Options.

Click Accept to enable the selected options or Cancel to ignore all changes. Click Reset to Defaults and then Accept to apply default option values.

General Options.  This group includes:

  • Use colorful status icons: Enables a colorful style of icons for the tray of MySQL Notifier. Selected by default.

  • Run at Windows Startup: Allows the application to be loaded when Microsoft Windows starts. Deselected by default.

  • Automatically Check For Updates Every # Weeks: Checks for a new version of MySQL Notifier, and runs this check every # weeks. Selected by default with the updates every four weeks.

  • Automatically add new services whose name contains: The text used to filter services and add them automatically to the monitored list of the local computer running MySQL Notifier and on remote computers already monitoring Windows services. Selected by default for names containing mysql.

  • Ping monitored MySQL Server instances every # seconds: The interval (in seconds) to ping monitored MySQL Server instances for status changes. Longer intervals might be necessary if the list of monitored remote instances is large. 30 seconds by default.

Notification Options.  This group includes:

  • Notify me when a service is automatically added: Display a balloon notification from the taskbar when a newly discovered service is added to the monitored services list. Selected by default.

  • Notify me when a service changes status: Displays a balloon notification from the taskbar when a monitored service changes its status. Selected by default.

MySQL Server Connections Options.  This group includes:

  • Automatic connections migration delayed until: When there are connections to migrate to MySQL Workbench (if installed), this option postpones the migration by one hour, one day, one week, one month, or indefinitely.

Managing Monitored Items

The Actions, Manage Monitored Items menu enables you to add, configure, and delete the services and MySQL instances you intend to monitor. The Manage Items window has two tabs: Services and Instances.

Services Tab.  When MySQL is configured as a local service, MySQL Notifier adds the service to the Services tab automatically. With the Services tab open, you can select the following options that apply to all services being monitored:

  • Notify me when status changes

  • Update MySQL Notifier tray icon based on service status

The next figure shows the Services tab open and both options selected. This tab shows the service name, the computer where the service is hosted, and the current status of the service.

Figure 2.15 MySQL Notifier: Manage Services

Content is described in the surrounding text.

To stop monitoring a service, select it from the list of monitored services and click Delete.

Click Add and then Windows Service to open the Add Service window. To add a new service, select a computer from the drop-down list, choose a service from the list, and then click OK to accept. Use the Filter field to reduce the set of services in the list or select Only show services that match auto-add filter? to reuse the general-options filter from the Options menu.

A variety of Windows services (including MySQL) may be selected as the following figure shows. In addition to the service name, the list shows the current status of each Windows services for the selected computer.

Figure 2.16 MySQL Notifier: Adding New Services

Content is described in the surrounding text.

Instances Tab.  When MySQL is configured as a MySQL instance, MySQL Notifier adds the instance to the Instances tab automatically. With the Instances tab open, you can select the following options that apply to each instance being monitored:

  • Notify me when status changes

  • Update MySQL Notifier tray icon based on service status

  • Monitor MySQL Instance status every [ # ] [ seconds | minutes | hours | days ]

The next figure shows the Instances tab open and both options selected. Monitoring the instance status is set to every two minutes in this example. This tab shows the instance name, the database driver, and the current status of the instance.

Figure 2.17 MySQL Notifier: Manage MySQL Instances

Content is described in the surrounding text.

To stop monitoring an instance, select it from the list of monitored MySQL instances and click Delete.

Click Add and then MySQL Instances to open the Monitor MySQL Server Instance window. Use the Filter field to reduce the set of instances in the list or select Show MySQL instances already being monitored? to show monitored items only.

Optionally, you can select a connection from MySQL Workbench to monitor. Click Add New Connection, shown in the next figure, to create a new connection.

Figure 2.18 MySQL Notifier: Adding New Instances

Content is described in the surrounding text.

Troubleshooting

For issues that are not documented here, visit the MySQL Notifier Support Forum for MySQL Notifier help and support.

  • Problem: attempting to start/stop/restart a MySQL service might generate an error similar to "The Service MySQLVERSION failed the most recent status change request with the message "The service mysqlVERSION was not found in the Windows Services".

    Explanation: this is a case-sensitivity issue, in that the service name is MySQLVERSION compared to having mysqlVERSION in the configuration file.

    Solution: either update your MySQL Notifier configuration file with the correct information, or stop MySQL Notifier and delete this configuration file. The MySQL Notifier configuration file is located at %APPDATA%\Oracle\MySQL Notifier\settings.config where %APPDATA% is a variable and depends on your system. A typical location is "C:\Users\YourUsername\AppData\Running\Oracle\MySQL Notifier\settings.config" where YourUsername is your system's user name. In this file, and within the ServerList section, change the ServerName values from lowercase to the actual service names. For example, change mysqlVERSION to MySQLVERSION, save, and then restart MySQL Notifier. Alternatively, stop MySQL Notifier, delete this file, then restart MySQL Notifier.

  • Problem: when connecting to a remote computer for the purpose of monitoring a remote Windows service, the Add Service dialog does not always show all the services shown in the Windows Services console.

    Explanation: this behavior is governed by the operating system and the outcome is expected when working with nondomain user accounts. For a complete description of the behavior, see the User Account Control and WMI article from Microsoft.

    Solution: when the remote computer is in a compatible domain, it is recommended that domain user accounts are used to connect through WMI to a remote computer. For detailed setup instructions using WMI, see Section 2.3.4.2, “Setting Up Remote Monitoring in MySQL Notifier”.

    Alternatively, when domain user accounts are not available, Microsoft provides a less secure workaround that should only be implemented with caution. For more information, see the Description of User Account Control and remote restrictions in Windows Vista KB article from Microsoft.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.