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
