SQWareProduction:mysql:etc:sqwmys CreInst MyCnf 51.cfg

Configuration file $gvsqw_MysBin/../etc/sqwmys_CreInst_MyCnf_51.cfg:



File content:

# Example MySQL config file for large systems.
# This is for a large system with memory = 512M where the system runs mainly
# MySQL.
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set host_name-specific options (in this
# installation this directory is /mysql-data-dir/myisam_data) or
# ~/.my.cnf to set user-specific options.
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = <lvsqw_PortNumber>
socket          = <gvsqw_MysqlSock>

# Here follows entries for some specific programs

# The MySQL host_name
[mysqld]
port            = <lvsqw_PortNumber>
socket          = <gvsqw_MysqlSock>
#PJC
bind-address    = <gvsqw_Hostname>
log-error=<gvsqw_RootAdmin>/logs/<MYSQL_SID>.log
innodb_data_home_dir=<gvsqw_RootDev>/ibdata
innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend
innodb_log_group_home_dir=<gvsqw_RootDev>/iblogs
innodb_lvsqw_LogFiles_in_group=2
innodb_flush_log_at_trx_commit=1
# end PJC
skip-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#skip-networking

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
host_name-id    = 1

[mysqlDump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout