datadir=/var/lib/mysql
#datadir=/media/raid0/mysql
socket=/var/lib/mysql/mysql.sock
#socket=/media/raid0/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=0
max_connections=500
max_connect_errors=10000
#innodb_buffer_pool_size=60400M
#temp change 60G
#innodb_buffer_pool_size=60G
innodb_buffer_pool_size=100G
max_allowed_packet=32M
#innodb
innodb_log_file_size = 1024M
innodb_log_buffer_size = 64M
#innodb_additional_mem_pool_size = 20M
#faster performance -- this is a slave -- use 2 instead of 0
innodb_flush_log_at_trx_commit = 2
innodb_flush_method=O_DIRECT
/etc/my.cnf [[contents]]
[mysqld]
event_scheduler=ON
# 20131104 disabled large pages
#large-pages
skip-name-resolve
query_cache_type = 1 builtin- innodb
query_cache_size = 1024M
#ignore-
#plugin- load=innodb= ha_innodb_ plugin. so dir=/usr/ lib64/mysql/ plugin
#plugin_
datadir= /var/lib/ mysql /media/ raid0/mysql /var/lib/ mysql/mysql. sock /media/ raid0/mysql/ mysql.sock errors= 10000 buffer_ pool_size= 60400M buffer_ pool_size= 60G buffer_ pool_size= 100G packet= 32M
#datadir=
socket=
#socket=
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=0
max_connections=500
max_connect_
#innodb_
#temp change 60G
#innodb_
innodb_
max_allowed_
#innodb log_file_ size = 1024M log_buffer_ size = 64M additional_ mem_pool_ size = 20M flush_log_ at_trx_ commit = 2 flush_method= O_DIRECT
innodb_
innodb_
#innodb_
#faster performance -- this is a slave -- use 2 instead of 0
innodb_
innodb_
#innodb_ buffer_ pool_instances= 8 write_io_ threads= 16 read_io_ threads= 16 file_per_ table=1 lock_wait_ timeout= 1073741824 lock_wait_ timeout= 240
#innodb_
#innodb_
innodb_
#innodb_
innodb_
#sort_buffer_size and read_buffer_size are per connection buffer_ size = 32M
sort_buffer_size = 8M
read_buffer_size = 2M
read_rnd_
join_buffer_size = 8M
#join_cache_level = 4
#tmp_table_size = 512M #20131104
#tmp_table_size = 100G
tmp_table_size = 600G
max_heap_ table_size= 600G isolation= repeatable- read
transaction-
#myisam sort_buffer_ size = 4294967295 sort_buffer_ size = 4G sort_buffer_ size = 2G
#key_buffer_size = 8589934592
#key_buffer_size = 24884901888
#temp change og 24G
#key_buffer_size = 24G
#key_buffer_size = 6G # 20131104
key_buffer_size = 5G
thread_cache_size = 32
table_open_cache = 1024
#myisam_
#temp change 4G
#myisam_
myisam_
server-id=1113306 updates= 1 do-db=revolvecl othing_ com_-_db ignore- db=mysql ignore- db=do_not_ replicate queries= /var/log/ mysql/mysql- slow.log log_file= /var/log/ mysql/mysql- slow.log relay-bin- admin1113306 index=relay- bin-admin111330 6.index ignore- table=revolvecl othing_ com_-_db. shoppingprefdat a ignore- table=revolvecl othing_ com_-_db. usercartdata ignore- table=revolvecl othing_ com_-_db. usercartdatasyn c ignore- table=revolvecl othing_ com_-_db. lastvisited ignore- table=revolvecl othing_ com_-_db. lastvisited2
low_priority_
#disable log-bin to suppress binary logs
#log-bin=mysql-bin
binlog-
binlog-
binlog-
#log-slow-
slow_query_log=1
slow_query_
long_query_time=1
skip-slave-start
relay-log=
relay-log-
replicate-
replicate-
replicate-
#replicate-
replicate-
# Disabling symbolic-links is recommended to prevent assorted security risks .. might be needed for partition
symbolic-links=1
# disable log warning
log_warnings=0
# Using too big key for internal temp tables switch= derived_ with_keys= off
# DONT CHANGE YET -- optimizer_
#temporary -- skip missing replication records
#1062 dup errors
#1146
slave-skip-errors = 1032,1034,1062,1146
[mysql.server] /var/run/ mysqld/ mysqld. pid
user=mysql
#basedir=/var/lib
pid-file=
[mysqld_safe] /var/log/ mysql/mysqld. log /var/run/ mysqld/ mysqld. pid
log-error=
#pid-file=
[mysql]
port = 3306 raid0/mysql/ mysql.sock mysql/mysql. sock
#socket = /media/
socket = /var/lib/