home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
server1.supportwizard.com
/
2014.06.server1.supportwizard.com.tar
/
server1.supportwizard.com
/
pub
/
my.cnf
< prev
next >
Wrap
Text File
|
2012-01-31
|
3KB
|
106 lines
#This File was made using the WinMySQLadmin 1.1 Tool
#06.07.2001 15:27:55
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
# Applied performance settings, 28.04.2005 + 4.07.2005 (7343) + 14.07.2005 (7343) + added 1G for innodb buffer pool size as decided at the meeting
# Applied kir's parameter - innodb_locks_unsafe_for_binlog=1
[mysqld]
user=mysqlusr
# Next line modified by ProcessConfigFileTask:
basedir = /ewdata/database/mysql
# Next line modified by ProcessConfigFileTask:
datadir = /ewdata/database/mysql/data
# Next line modified by ProcessConfigFileTask:
port = 3333
key_buffer=48M
connect_timeout=20
# Next line modified by ProcessConfigFileTask:
max_connections = 370
# Next line modified by ProcessConfigFileTask:
log_error = /ewdata/database/mysql/logs/ewmysql-error.log
# log-slow-queries=@MYSQL.LOG.DIR@ewmysql-slow-queries.log
slow_query_log=1
# Next line modified by ProcessConfigFileTask:
slow_query_log_file = /ewdata/database/mysql/logs/ewmysql-slow-queries.log
# default-character=utf8
character-set-server=utf8
# default-collation=utf8_general_ci
collation-server=utf8_general_ci
default-storage-engine=InnoDB
# INNODB
#######################
# begin of changes made by Tolik
# next line commented
innodb_data_file_path=ibdata1:1034M;ibdata2:100M:autoextend
# next sevaral lines added
innodb_file_per_table
innodb_strict_mode=0
ignore-builtin-innodb
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
innodb_file_format=Barracuda
innodb_file_format_check=Barracuda
innodb_fast_shutdown=0
# End of changes made by Tolik
#######################
# Next line modified by ProcessConfigFileTask:
innodb_data_home_dir = /ewdata/database/mysql/innodb
innodb_mirrored_log_groups=1
# Next line modified by ProcessConfigFileTask:
innodb_log_group_home_dir = /ewdata/database/mysql/innodb
innodb_log_files_in_group=3
innodb_log_file_size=268435456
innodb_log_buffer_size=16M
innodb_flush_log_at_trx_commit=0
innodb_locks_unsafe_for_binlog=1
max_allowed_packet=96M
# innodb_log_arch_dir=@MYSQL.INNODB.DIR@
# innodb_log_archive=0
# Next line modified by ProcessConfigFileTask:
innodb_buffer_pool_size = 2422M
innodb_additional_mem_pool_size=100M
innodb_file_io_threads=4
innodb_lock_wait_timeout=150
# @UNCOMMENT.UNDER.UNIX@innodb_flush_method=O_DIRECT
innodb_flush_method=O_DIRECT
sort_buffer_size=5M
read_buffer_size=1M
table_cache=2048
join_buffer_size=5M
query_cache_type=1
query_cache_size=64M
query_cache_limit=5M
tmp_table_size=64M
sql-mode=NO_AUTO_VALUE_ON_ZERO
net_read_timeout=1000
net_write_timeout=1000
# Next line(s) added by ProcessConfigFileTask: