Users Guide

MySQL Server Configuration File Examples | Database Management
158 OMNM 6.5.3 Installation Guide
MySQL Server Configuration File Examples
The my.cnf files optimize MySQL installations for the database size you configure at installation
time. Refer to the
OpenManage Network Manager User Guide for more suggestions about re/sizing
your MySQL database, as well as starting, stopping and performance tuning it.
Several my.cnf files and example
*.ini files ( my-small.ini , my-large.ini , and so on)
accompany standard installations, but the origin of the configuration on Linux is
/opt/dorado/
oware3rd/mysql/[version number]/my.cnf
, and on Windows is \oware3rd\
mysql\[version number]\my.cnf
so be sure to alter that file if you are optimizing MySql.
The following are examples of
my.cnf files for the configurations described above:
•
6GB example (default):
• 8GB example:
• 12GB example:
• 16GB example:
• 32GB example:
CAUTION:
Some Linux distributions have MySQLinstalled by default. Remove any previous MySQL installation, and
make sure to remove or rename the
my.cnf file for that previous installation. If it is on the path, it can
interfere with the correct operation of OpenManage Network Manager.
Refer to the OpenManage Network Manager User Guide for additional advice about my.cnf
configuration.
6GB example (default):
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable = connect_timeout=10
set-variable = key_buffer=384M
set-variable = max_allowed_packet=32M
set-variable = table_cache=1024
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
server-id = 1
transaction-isolation = READ-COMMITTED
# Uncomment the following if you want to log updates
#log-bin
innodb_locks_unsafe_for_binlog=1