MySQL Server Guide

The InterWorx Control Panel provides and easy-to-use interface for managing the System-level MySQL Service.

From the MySQL Overview page in NodeWorx, server administrators may manage the start-up options for the MySQL service, reset the MySQL root password, terminate existing MySQL queries, and control MySQL settings.

To Manage the MySQL Service

Checking MySQL Status

  1. Log into NodeWorx from the browser (https://ip.ad.dr.ess:2443/nodeworx)

  2. In NodeWorx, navigate to System Services > MySQL Server > Overview

  3. Under MySQL Server Control, the MySQL Status bar indicates the current status of the service

    • It is also possible to control the status of the service from this interface:

      • Play starts the service

      • Arrow restarts/refreshes the service

      • Stop stops the service

    mysql status

Setting MySQL Start-On-Boot Options

  1. Log into NodeWorx from the browser (https://ip.ad.dr.ess:2443/nodeworx)

  2. In NodeWorx, navigate to System Services > MySQL Server > Overview

  3. Under MySQL Control, select either Yes or No from the Start on Boot-up dropdown

  4. Click Update

Setting MySQL Auto-Restart Options

  1. Log into NodeWorx from the browser (https://ip.ad.dr.ess:2443/nodeworx)

  2. In NodeWorx, navigate to System Services > MySQL Server > Overview

  3. Under MySQL Control, select either Yes or No from the Auto-restart MySQL dropdown

  4. Click Update

To Change the MySQL Root Password

  1. Log into NodeWorx from the browser (https://ip.ad.dr.ess:2443/nodeworx)

  2. In NodeWorx, navigate to System Services > MySQL Server > Overview

  3. Under MySQL Root Password update the Password and Confirm Password options with the new password

    mysql root password

  4. Click Update

To Terminate Running MySQL Queries

  1. Log into NodeWorx from the browser (https://ip.ad.dr.ess:2443/nodeworx)

  2. In NodeWorx, navigate to System Services > MySQL Server > Overview

  3. Under Current MySQL Processes, select the checkbox next to the processes/queries to be terminated

    Note

    If there are no active or running processes, the Current MySQL Processes section will state “No Active MySQL Processes/Queries”.

  4. From the With Selected dropdown, select Terminate

    mysql processes

  5. Click Go

To Edit MySQl Service Options

The most common configuration options are exposed in the InterWorx Control Panel. As with many of the system services, a system administrator still retains the ability to configure the service by editing the configuration file.

  1. Log into NodeWorx from the browser (https://ip.ad.dr.ess:2443/nodeworx)

  2. In NodeWorx, navigate to System Services > MySQL Server > Overview

  3. Under MySQL Server Options, update the desired fields:

    • Connections: The maximum number of simultaneous connections allowed for MySQL

      Note

      Increasing max_connections increases the number of file descriptors that mysqld requires. It is strongly suggested that the maximum number of connections is kept below 1500.

    • Connection Errors: The maximum number of allowed connection errors for a given host

    • Connect Timeout: The maximum number of seconds before a connection to the MySQL server will time out

    • Wait Timeout: The number of seconds the server waits for activity on a connection before closing the connection

    • Key Buffer Size: The key buffer is a memory buffer shared by all threads. Increasing the key buffer size will result in better index handling for all reads, and multiple writes

      Note

      If set too large, for instance more than 50% of the total memory, the system may start to page and become extremely slow. It is important to remember that, because MySQL does not cache data reads, leaving some room for the OS filesystem cache is required.

    • Sort Buffer Size: The size of the buffer used when sorting table data. Increasing this value will lead to faster ORDER BY or GROUP BY operations

    • Read Buffer Size: Each thread that does a sequential scan allocates a buffer of this size for each table it scans. If many sequential scans are performed regularly, it may be prudent to increase this value

    • Maximum Allowed Packet Size: The maximum size of one packet. By default, the value is small so as to catch large, possibly wrong, packets. Using big BLOB columns will require increasing this value, so that it is large as the biggest BLOB in use

    • Thread Cache Size: The number of threads that are kept in the cache for reuse. This variable can be increased to improve performance if there are a lot of new connections.Increasing this value increases the number of file descriptors that mysqld requires

    • Open Table Cache: This variable controls the number of open tables that are cached. Table cache is related to max connections. For example, for 200 concurrent running connections, the table cache should be set to at leat 200 * N, where N is the maximum number of tables in a join. If this value is increased, the number of file descriptors needed by mysqld will also increase

    • Query Cache Limit: Sets the maximum amount of memory to be allocated for storage of old query results

    • Query Cache Size: Sets size of the query cache. If set to 0, query caching is disabled

    mysql server options

  4. Click Update