/etc/my.cnf [[contents]]


[mysqld]
event_scheduler=ON
# 20131104 disabled large pages
#large-pages
skip-name-resolve

query_cache_type = 1
query_cache_size = 1024M
#ignore-builtin-innodb

#plugin-load=innodb=ha_innodb_plugin.so
#plugin_dir=/usr/lib64/mysql/plugin

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

#innodb_buffer_pool_instances=8
#innodb_write_io_threads=16
#innodb_read_io_threads=16
innodb_file_per_table=1
#innodb_lock_wait_timeout=1073741824
innodb_lock_wait_timeout=240

#sort_buffer_size and read_buffer_size  are per connection
sort_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 32M
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
transaction-isolation=repeatable-read


#myisam
#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_sort_buffer_size = 4294967295
#temp change 4G
#myisam_sort_buffer_size = 4G
myisam_sort_buffer_size = 2G

server-id=1113306
low_priority_updates=1
#disable log-bin to suppress binary logs
#log-bin=mysql-bin
binlog-do-db=revolveclothing_com_-_db
binlog-ignore-db=mysql
binlog-ignore-db=do_not_replicate
#log-slow-queries=/var/log/mysql/mysql-slow.log
slow_query_log=1
slow_query_log_file=/var/log/mysql/mysql-slow.log
long_query_time=1
skip-slave-start
relay-log=relay-bin-admin1113306
relay-log-index=relay-bin-admin1113306.index
replicate-ignore-table=revolveclothing_com_-_db.shoppingprefdata
replicate-ignore-table=revolveclothing_com_-_db.usercartdata
replicate-ignore-table=revolveclothing_com_-_db.usercartdatasync
#replicate-ignore-table=revolveclothing_com_-_db.lastvisited
replicate-ignore-table=revolveclothing_com_-_db.lastvisited2
# 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
# DONT CHANGE YET -- optimizer_switch=derived_with_keys=off

#temporary -- skip missing replication records
#1062 dup errors
#1146
slave-skip-errors = 1032,1034,1062,1146

[mysql.server]
user=mysql
#basedir=/var/lib
pid-file=/var/run/mysqld/mysqld.pid


[mysqld_safe]
log-error=/var/log/mysql/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid

[mysql]

port                           = 3306
#socket                         = /media/raid0/mysql/mysql.sock
socket                         = /var/lib/mysql/mysql.sock