Chapter 8. Service Control

Table of Contents

8.1. Introduction
8.2. Start/Stop Service
8.3. Configure Service

8.1. Introduction

This section shows how to start and stop the MySQL server you have connected to. Currently, this is only possible if the server is running on the same machine that hosts MySQL Administrator and if that service has been configured. (Future releases will be capable of starting and stopping MySQL servers on remote machines.) If the server runs as a stand-alone application, the Service Control section will not be enabled.

The Configure Service tab is available only for MySQL servers that run under Windows.

8.2. Start/Stop Service

The Start/Stop Service tab displays the status of the MySQL service. This service starts and stops the MySQL server. Under Service Status, a text message indicates whether or not the service has been started. If the service is running, the button label is Stop Service. Click it to stop the server. If the service is stopped, the button label is Start Service. Click it to start the service.

Under Log Messages, you will find messages that the MySQL server produces when it starts or stops. Messages produced by the server during startup look something like this:

Trying to start the server ...
040119 18:33:41  InnoDB: Started
MySql: ready for connections.
Version: '4.0.16-max-nt-log'  socket: ''  port: 3306
Server was started.

When the server stops, it produces messages such as these:

Trying to stop the server ...
040119 18:31:45  MySql: Normal shutdown
040119 18:31:46  MySql: Forcing close of thread 11  user: 
'superuser'
040119 18:31:46  MySql: Forcing close of thread 8  user: 'superuser'
...
Server was stopped.

The details and format of the messages might vary depending on the version of the MySQL server you are using and its configuration.

8.3. Configure Service

Use this tab to configure the Windows service that starts and stops the MySQL server and to set server options This tab is specific to MySQL servers running under operating systems of the Windows NT family, including Windows NT, Windows 2000, and Windows XP; it is not available for servers running under a different operating system. Obviously, you need to have a Windows service installed before you can configure it. See Starting MySQL as a Windows Service, for more information on how to set up a Windows service.

Note that if you have more than one MySQL server running as a Windows service, you should run MySQL Administrator in configure-service mode to administer these services. In normal mode, you can only administer the Windows service listed first in the Windows service manager, no matter which server you are connected to.

Note that the settings in the Server Features group take effect only after restarting the MySQL server.

The following settings are available:

  • Service Settings

    • Launch MySQL server automatically: If checked, the Windows service starts the MySQL server automatically on operating system startup.

    • Display Name: The display name of the Windows service (not the service name!) as it will appear in the Windows services manager when displaying the properties of that service.

    • Service Description: The description of the Windows service as it will appear in the Windows services manager.

  • Option File

    • Config Filename: You can enter the pathname of the server option file. MySQL will enter that information in the Windows registry, and the Windows service starting the MySQL server will use that file, rather than the default file (C:\windows installation directory\my.ini). Note that this is available for MySQL servers as of version 4.0.3 only. See Creating an Option File, for details about the server option files.

    • Section Name: Setting a value other than mysqld is most useful when running multiple servers; see Running Multiple Servers on Windows.

  • Server Features

    Note that all server features will only take effect after the MySQL server has been restarted.

    • Support for InnoDB: If checked, the MySQL server is started with support for InnoDB tables. If unchecked, it doesn't start the InnoDB storage engine; this saves memory, but InnoDB tables cannot be used. If this checkbox is unchecked and greyed out, it means that your MySQL server isn't compiled with support for InnoDB tables. (This is, for example, true for some versions that run under a commercial license.) For more information on InnoDB tables, see Storage Engines and Table Types.

      Be careful when disabling this option! If any databases on the MySQL server contain InnoDB tables, disabling this option makes those tables inaccessible.

    • Support for BDB: If checked, the MySQL server is started with support for BDB tables. If unchecked, it doesn't start the BDB storage engine; this saves memory, but BDB tables cannot be used. If this checkbox is unchecked and greyed out, it means that your MySQL server isn't compiled with support for BDB tables. (This is, for example, true for non-max versions.) For more information on BDB tables, see Storage Engines and Table Types.

      Be careful when disabling this option! If any databases on the MySQL server contain BDB tables, disabling this option makes those tables inaccessible.

    • Named Pipes: On operating systems of the Windows NT family, including Windows NT, Windows 2000, and Windows XP, you may use named pipes to connect to a MySQL server running on the local machine, rather than connecting via TCP/IP. If this option is checked, named pipe connections are allowed. Note that named pipes are slower than TCP/IP in many Windows configurations. See Selecting a MySQL Server type.

    • Debug Information (slow): If checked, the MySQL server is started with an option that allows for easier debugging of problems. Using this option slows down the server significantly, so it is recommended only for debugging purposes. If the MySQL server has not been compiled with debugging support, this option is greyed out. See Command Options.

    • Path to Binary: Contains the pathname of the MySQL server binary file as it is listed in the Windows service manager (for example C:\mysql\bin\mysqld-max-nt). Note that the the Windows service manager does not display the .exe extension.