Skip to content
Thoroughbred Software InternationalThoroughbred Software InternationalThoroughbred DocumentationDocs

MySQL Configuration

To run TS DataServer for MySQL the following changes must be made to the default MySQL configuration:

  • Use the InnoDB plugin:
    • Ignore the internal InnoDB storage engine
    • Set the location of the MySQL plugins directory
    • Load the InnoDB plugin
  • Set the default storage engine to InnoDB
  • Set the transaction isolation level
  • Set the InnoDB transaction timeout value to 15 seconds.
  • Set/increase the maximum size of a packet or generated string.
  • Set/increase the time the MySQL server will wait before closing a connection due to inactivity.
  • Change the character set and collation to Latin.

For MySQL 5.1, these changes can be made by adding the following to the MySQL configuration file my.cnf:

[mysqld]
ignore_builtin_innodb
plugin_dir = /usr/lib/mysql/plugin
plugin_load = innodb=ha_innodb_plugin.so

; innodb_trx=ha_innodb_plugin.so
; innodb_locks=ha_innodb_plugin.so
; innodb_lock_waits=ha_innodb_plugin.so
; innodb_cmp=ha_innodb_plugin.so
; innodb_cmp_reset=ha_innodb_plugin.so
; innodb_cmpmem=ha_innodb_plugin.so
; innodb_cmpmem_reset=ha_innodb_plugin.so

default-storage-engine = InnoDB
transaction-isolation = READ-COMMITTED
innodb_lock_wait_timeout = 15
# for large text fields
max_allowed_packet = 32M

Note: The plugin_load option value must be written as a single line without spaces.

For MySQL 5.1 64-bit, the location of the InnoDB plugin may be different from the 32-bit version. If necessary, set the plugin_dir option to the following value instead of the above value:

plugin_dir = /usr/lib64/mysql/plugin

For MySQL 5.5 and MySQL 5.6, these changes can be made by adding the following to the MySQL configuration file my.cnf:

[mysqld]
transaction-isolation = READ-COMMITTED innodb_lock_wait_timeout = 15

Terminal window
# for large text fields
max_allowed_packet = 32M

For MySQL 8.0, the following changes must be made to the MySQL configuration:

.[mysqld]
transaction-isolation = READ-COMMITTED
innodb_lock_wait_timeout = 15
# innodb_page_size = 32KB

innodb_strict_mode = OFF
# for large text fields:
# max_allowed_packet = 32M
# to prevent error 2006:
wait_timeout=86400
# UTF8 overrides for MySQL 8.0
skip-character-set-client-handshake
collation-server=latin1_general_ci
character-set-server=latin1

The MySQL service must be restarted in order for the above changes to take effect.

Starting with release level 8.9.0, a tsmysql.cnf file will be included in the master file. This configuration file can be copied into the MySQL configuration directory to enable the changes in the MySQL server needed by TS DataServer for MySQL to function properly.

The mysql.sock file

Section titled “The mysql.sock file”

An empty file named mysql.sock is created when MySQL is running on a system. This file is usually located in the /var/lib/mysql directory. The permissions on the directory where the mysql.sock file is located must be at least 755 ( i.e. drwxr-xr-x ).

From the TS DataServer for MySQL Reference, version 8.9.1. Open this page in the PDF