MySQL configuration file Simple parsing

1 [Mysqld]2Basedir =/data/MySQL3DataDir =/data/Mysqldata4Tmpdir =/data/mysqltmpdata//mysql Query Temp directory, avoid due to lack of disk space, resulting in related5Port =33066Socket =/data/mysql/Mysql.sock7init-connect='SET NAMES UTF8the '//connected character set is UTF88character-Set-server =UTF8//The default character set for the system is UTF89Lower_case_table_names =1Ten  OneBack_log =1024x768 AMax_connections = the -Max_connect_errors =100000 -Expire_logs_days =5 theMax_allowed_packet =16M -Binlog_cache_size =5M -Max_heap_table_size =32M -Tmp_table_size =32M +Sort_buffer_size =8M -Join_buffer_size =8M +Ft_min_word_len =4 AThread_stack =254K atThread_cache_size = - -Query_cache_type =0 -Query_cache_size =0 -  -  -log-bin=master-bin inbinlog-format=row//binary log format in row mode -log-error=/var/log/Mysqld.log toSlow_query_log =1 +Slow-query-log-file = mysql-Slow.log -Long_query_time =1 the  *  $Server-id = toPanax Notoginsengreplicate-ignore-db=Test//Master-slave copy skips the test library and related tables, as well as MySQL library and related tables -replicate-wild-ignore-table=test.% thereplicate-ignore-db=MySQL +Replicate-wild-ignore-table=mysql.% Askip-slave-Start the log_slave_updates +  -  $Wait_timeout =28800 $Interactive_timeout =28800 -Skip-name-resolve= on -skip-external-Locking the  - Wuyi default-storage-engine =InnoDB theTransaction_isolation = repeatable-READ -Innodb_buffer_pool_size =9G//The value here is probably the 70%-80% of the total system memory WuInnodb_strict_mode =1 -Innodb_file_per_table =1 AboutInnodb-open-files =655350 $innodb_write_io_threads= - -innodb_read_io_threads= - -Innodb_thread_concurrency =0 -innodb_io_capacity= + AInnodb_flush_log_at_trx_commit =1 +Innodb_log_buffer_size =32M theInnodb_log_file_size =512M -Innodb_log_files_in_group =2 $Innodb_adaptive_flushing =1 theinnodb_max_dirty_pages_pct = - theInnodb_lock_wait_timeout = - theInnodb_fast_shutdown =0 theInnodb_flush_method =O_direct -Innodb_stats_on_metadata =0 in  the  theInnodb_buffer_pool_instances =8 Aboutsysdate- is- Now the Performance_schema theSql_mode="' theauto_increment_offset=1//The starting value of the self-increment field is 1 +Auto_increment_increment=2//self-increasing spacing of 2 -  the Bayi [mysqldump] the Quick theMax_allowed_packet =16M -  - [MySQL] the default-character-Set=UTF8 thePager= More theno-auto-Rehash theSocket =/data/mysql/Mysql.sock//Add this configuration in order to avoid the use of MySQL command to directly connect the MySQL sock file because it is not configured separately -  the [Myisamchk] theKey_buffer =512M theSort_buffer_size =512M94Read_buffer =8M theWrite_buffer =8M the  the [Mysqlhotcopy]98interactive-Timeout About  - [Mysqld_safe]101pid-file=/var/run/mysqld/Mysqld.pid102Open-files-limit =65535103user = MySQL

MySQL configuration file Simple parsing