끄적끄적_DB

[mysqld]

port                =3333

socket            =/tmp/service_mysql.sock

user = mariadb

server-id = 1

basedir = /mariadb/service/instance

datadir = /servicedata/service/datadir

tmpdir  = /servicedata/servicetmpdir

character-set-server  = utf82    ## utf8mb4 는 이미지까지 받아주는 걸로 알고있다.

collation-server = utf8_bin

default_storage_engine = InnoDB

event_scheduler = on

sysdatae-id-now

performance_schema = on

back_log = 100

max_connections = 4000

max_connect_errors = 99999

max_statament_time = 7200

table_open_cache = 2048

wait_timeout = 3600

interactive_timeout = 3600

max_allowed_packet = 32M

max_heap_table_size = 128M

tmp_table_size = 128M

sort_buffer_size = 256K

join_buffer_size = 256K

read_buffer_size = 256K

read_rnd_buffer_size = 256K

query_cache_type = 0

query_cache_size = 0

query_cache_limit = 0

transaction_isolation = READ-COMMITTED

optimizer-switch='split_materialized=off'

plugin-load = unix_socket=auth_socket.so

#### InnoDB Specific Options ####

innodb_data_file_path = ibdatal:1G:autoextend

innodb_file_per_table = 1

innodb_buffer_pool_size = 32G

innodb_log_buffer_size = 64M

innodb_log_file_size = 1G

innodb_log_files_in_group = 2

innodb_autoextend_increment = 256

innodb_flush_log_at_trx_commit = 1

innodb_flush_method=O_DIRECT

innodb_lock_wait_timeout = 120

### MyISAM Specific options ###

key_buffer_size = 64M

bulk_insert_buffer_size = 64M

myisam_sort_buffer_size = 128M

myisam_repair_threads = 1

### Logging Options ###

log_bin = /servicebinary/binlog

general_log = 0

ezpire_logs_days = 5

slow_query_log = 1

long_query_time = 5

log_error = /servicedata/service/logdir/error.log

slow_query_log_file = /servicedata/service/logdir/slow.log

general_log_file = /servicedata/service/logdir/general.log

#### DBA CONFig ####

lower_case_table_name = 1

skip_name_resolve

skip_external_locking

log_slow_verbosity = 'explain'