Mariadb-my.cnfファイルの詳細

[client]									#        
default-character-set = utf8				#     (mariadb      )
port = 3306									#    
socket = /data/mydata/mysql.sock			#  socket

[mysql]				#    mysql       
port = 3306
socket = /data/mydata/mysql.sock
default-character-set  = utf8

[mysqld]						#  mysql-server    
user = mysql					#       mysql(    mysql     ),    ,    mysql        
default-storage-engine  = InnoDB #       innodb,(              )
socket = /data/mydata/mysql.sock	#  
pid-file = /data/mydata/mysql.pid	#  

#      (  )
skip-name-resolve				#  DNS  
skip-host-cache					#       
#--skip-networking   			#  TCP/IP  
	
#      (  )
skip-external-locking #external-locking           Myisam     ,       ,                                  ,       ，           ,       。
	
#    
max_connections = 2000  		 #     (            )
max_allowed_packet = 64M  		 #  server       ,       ,     
table_open_cache = 2048	#    table      (    mysql    2G    256-512,4G    2048,      ,        )

#    
explicit_defaults_for_timestamp = 1  #    timetamp     , 1      null 
lower_case_table_names  = 0	#     
   3  
0             (  ,  )         
1            ,          
2 	         ,        
unix,linux    0,window 1(winods         )
		
#  colltion(    ),               ,     ,    。。。。	
collation-server utf8_general_ci 
character-set-server = utf8            
 ：colltion           ，          。
https://www.cnblogs.com/EasonJim/p/8128196.html  #           
	
#MyISAM 						# Myisam        
key-buffer-size = 32M			#         (       ),      Myisam  ,        。
myisam-recover-options = FORCE,BACKUP #    mysq   Myisam      , 4  ,     。
default:    ,         。
backup:             ,  MYD        tbl_name‐datetime.BAK。
force:  MYD        ，     
quick：       delete      。

#DATA STORAGE #
datadir = /data/mydata

#BINARY LOGGING        
log-bin = mysql-bin				#       
binlog_format = mixed			#binlog    ,    staterment,    mixed
expire-logs-days = 14			#  binlog      ,           14     
sync-binlog = 1					#           ,     mysql      
#max_binlog_size = 100M			#  binlog    
#binlog_cache_size = 10M  #binlog      
server-id  = 100				#       ID
performance_schema = 0 
max_connect_errors = 4294967295 #          (       ,              )，   ip     ,   mysql    
 :sysnc-bing    0,   n，
	    0 ,       ，MySQL  fsync           binlog_cache       ，  Filesystem            ，  cache          。
	    n ,n   1,2,    0,    ,        n       ,mysql   sync    , binlo_cache         。
	   
#CACHES(  ) AND LIMITS(  ) #          
	# tmp-table-size = 32M   		#           (        ),           ,       MyIsam ,      tmpdir   。
	# max-heap-table-size = 32M		#              ,              。
	 ：          ,        ,    ,                ,    ,         ,        ,    ,     。
	# query-cache-type = 0			#      select    ，        (              ), 3  ：
										0      ;
										1       ,  select    sql_no_cache      ;
										2    select            
	# query-cache-size = 0 			# 0      ,,     ,           ,   1024   ,   32M,128M.    query-cache-type     。
	max-connections = 1024			#  cache          
	thread-cache-size = 64			#         ,     3G   64(   show global status like 'Threads_%';       )
	open_files_limit = 65535	    #      ,                 
	table-definition-cache = 4096 	#        ,      frm        
	table-open-cache   = 512 		#             ,       ,              ,    。
	 ：        ？
	                                             ,            。


#INNODB #
innodb_data_file_path = ibdata1:2G:autoextend #      ，    ，                        
innodb-flush-method = O_DIRECT 				#   innodb     redo log   ,    ， 3  ：
												fdatasync(    )，  fsync()       redo log buffer
												O_DSYNC，innodb   O_SYNC       redo log,  fsync()      
												O_DIRECT，innodb  O_DIRECT      ，  fsync()       redo log												
innodb-log-files-in-group = 2 				#               ,   2
innodb-log-file-size = 1024M 				#        
innodb-flush-log-at-trx-commit = 1			#                 1 2          0        
innodb-file-per-table = 1					#       ,innodb    1    
innodb-buffer-pool-size  = 12G				#(   )      ,innodb    ，    ，                    70%-80%

#logging
log-error = /data/logs/mysql/mysql-error.log  #        
log-queries-not-using-indexes  = 0			#            
slow-query-log = 1							#     
slow-query-log-file = /data/logs/mysql/mysql-slow.log #         
long_query_time  = 1						#       ,   10s，               1  1s

#[mysqldump]	#  ,       
[mysqldump]
quick										#  mysqldump               
max_allowed_packet = 32M					#        

#[mysql]     	#   mysql   
[mysql] 
no-auto-rehash								#          

#[myisamchk] 
[myisamchk]  #    ,  mysqld                     
key_buffer_size   = 32M 					
sort_buffer_size  = 32M					
read_buffer = 8M
write_buffer = 8M

#[mysqlhotcopy]
[mysqlhotcopy]
interactive-timeout	
expire_logs_days  = 10
	#mysqlhotcopy  lock tables、flush tables cp scp        .                ,        ,       MyISAM                   
	# mysqldump    ,mysqldump      ,       sql  .  mysqlhotcopy                ..

#[mysqld_safe]
[mysqld_safe] # safe       ，   mysqld,               ，     
open-files-limit = 8192