my.cnf

[mysqld]

## MySQL Server Default Option ------------------------------------------------------------------

server-id = 1

user                            = mysql 

port                            = 3306  

basedir             = /usr

datadir                         = /data/mysql

tmpdir                          = /tmp

socket                          = /var/run/mysqld/mysqld.sock

character_set_server            = utf8mb4

collation-server                = utf8mb4_general_ci

default-storage-engine          = InnoDB

skip-name-resolve

skip-external-locking

## MySQL - event-scheduler = ON(true)/OFF(false)

event-scheduler                 = OFF   

sysdate-is-now

back_log                        = 100   

max_connections                 = 300  

max_connect_errors              = 999999

thread_cache_size               = 50    

max_allowed_packet              = 32M   

max_heap_table_size             = 32M   

tmp_table_size                  = 2M  

# For Per Connection

sort_buffer_size                = 256K  

join_buffer_size                = 256K  

read_buffer_size                = 256K  

read_rnd_buffer_size            = 256K

query_cache_size                = 32M   

query_cache_limit               = 2M    

group_concat_max_len            = 1024

## MySQL Isolation

transaction-isolation = READ-COMMITTED

## InnoDB Plug-in Option -----------------------------------------------------------------------------

innodb_adaptive_flushing        = ON

innodb_adaptive_hash_index      = 1

innodb_autoinc_lock_mode        = 1

innodb_change_buffering         = all

innodb_file_format              = barracuda

innodb_io_capacity              = 600

innodb_max_dirty_pages_pct      = 90

innodb_old_blocks_time          = 500

innodb_read_io_threads          = 6

innodb_stats_on_metadata        = 1

innodb_stats_sample_pages       = 8

innodb_strict_mode              = 0

innodb_use_sys_malloc           = 1

innodb_write_io_threads         = 6

ignore_builtin_innodb           = OFF

innodb_fast_shutdown = 0

## plugin-load setting

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 Default Option  -----------------------------------------------------------------------------

innodb_additional_mem_pool_size = 32M

innodb_autoextend_increment     = 100   

innodb_buffer_pool_size         = 11G

innodb_buffer_pool_instances    = 3

innodb_commit_concurrency       = 0     

innodb_concurrency_tickets      = 500   

innodb_data_file_path = ibdata1:3G;ibdata2:3G;ibdata3:3G;ibdata4:3G;ibdata5:3G;ibdata6:3G;ibdata7:3G;ibdata8:3G;ibdata9:3G;ibdata10:3G;ibdata11:100M:autoextend  

innodb_data_home_dir            = /data/mysql

innodb_doublewrite              = 1     

innodb_file_per_table           = 1     

innodb_flush_log_at_trx_commit  = 1

innodb_flush_method             = O_DIRECT

innodb_force_recovery           = 0     

innodb_lock_wait_timeout        = 60    

innodb_log_buffer_size          = 16M   

innodb_log_file_size            = 1G    

innodb_log_files_in_group       = 2     

innodb_log_group_home_dir       = /data/mysql

innodb_max_purge_lag            = 0     

innodb_support_xa               = OFF   

innodb_sync_spin_loops          = 20    

innodb_table_locks              = 1     

innodb_thread_concurrency       = 0     

innodb_thread_sleep_delay       = 1000  

## MyISAM Option -----------------------------------------------------------------------------

## Even if you're not using MyISAM tables, you should still set it to 8-64M as it will also be

## used for internal temporary disk tables.

## If you use MYISAM, you can set still key_buffer_size=4GB(max)

key_buffer_size                 = 32M

bulk_insert_buffer_size         = 32M

myisam_sort_buffer_size         = 1M

myisam_max_sort_file_size       = 1G

myisam_repair_threads           = 1

myisam_recover

ft_min_word_len                 = 3

## Logging Option -----------------------------------------------------------------------------

pid-file                        = /var/run/mysqld/mysqld.pid

log-warnings                    = 1

log-error                       = /data/log/mysql-error.log

## "SET GLOBAL general_log = 1" (true)

#general_log                     = 1

#general_log_file                = /data/log/mysql_general.log

log_slow_admin_statements

slow-query-log                  = 1

long_query_time                 = 1

slow_query_log_file             = /data/log/mysql-slow.log

log-output = FILE

### Replication Option ------------------------------------------------------------------------

## Master Server

#log-bin                       = /data/binlog/mysql-master-bin

#binlog_cache_size             = 128K

#max_binlog_size               = 512M  

#expire_logs_days               = 15    

#log-bin-trust-function-creators = 1

#sync_binlog                   = 1

#binlog_format = mixed

#binlog-ignore-db = information_schema

#binlog-ignore-db = performance_schema

#binlog-ignore-db = mysql

#binlog-ignore-db = test

## Slave Server

# relay-log                     = /data/binlog/mysql-relay-bin

# relay_log_purge               = TRUE  

# read_only

## Slave Server = Master Server

## This option tells the slave to log the updates performed by its SQL thread to its own binary log

# log-slave-updates

[client]

socket                          = /var/run/mysqld/mysqld.sock

port                            = 3306  

[mysql]

default-character-set = utf8

no-auto-rehash

show-warnings

prompt=\d\_\R:\m:\\s>

#pager="less -n -i -F -X -E"