Mysql configuration file example

Welcome to the Linux community forum and interact with 2 million technical staff to access [mysqld] port3306sockettmpmysql. sock # Set mysql installation directory basedirD: \ mysql-5.6.14-win32 # Set mysql database data storage directory, must be datadatadirD: \ mysql-5.6.14-win32 \ data # in

Welcome to the Linux community forum and interact with 2 million technical staff> go to [mysqld] port = 3306 socket =/tmp/mysql. sock # Set mysql installation directory basedir = D: \ mysql-5.6.14-win32 # Set mysql database data storage directory, must be data datadir = D: \ mysql-5.6.14-win32 \ data # in

Welcome to the Linux community forum and interact with 2 million technicians>

[Mysqld]

Port = 3306

Socket =/tmp/mysql. sock

# Set the installation directory of mysql

Basedir = D: \ mysql-5.6.14-win32

# Set the data storage directory of the mysql database, which must be data

Datadir = D: \ mysql-5.6.14-win32 \ data

# Innodb_log_arch_dir default datadir

# Innodb_log_group_home_dir default datadir

# Set the character set of the mysql server, default encoding

Default-character-set = utf8

# Number of operating system listening queues for the number of connections. You can add this value if the "Drop connection" error occurs frequently.

Back_log = 50

# Do not use the method of answering TCP/IP ports. mysqld uses the named pipe to connect

# Skip-networking

# Maximum number of connections

Max_connections = 100

# The maximum number of threads to open a table is 4096, unless you use mysqld_safe to open the limit

Table_open_cache = 2048

# MySql Service receives the maximum query package size for each process

Max_allowed_packet = 16 M

# Apply to the memory cache used by a single SQL query process. If the binary data of an operation exceeds the limited size, it will open up space for processing on the disk, which is generally set to 1-2 M. The default value is 1 M.

Binlog_cache_size = 2 M

# Maximum value limit for a single memory table

Max_heap_table_size = 64 M

# Sort buffer size allocated for each thread

Sort_buffer_size = 8 M

# The buffer size for join table operations. The default value is 8 Mb.

Join_buffer_size = 32 M

# Operation on the cache of the number of disconnected threads

Thread_cache_size = 8

# Number of concurrent threads. The default value is 8, which can be increased to less than 2 times. If multiple CPUs exist, you can multiply the number of CPUs. The dual-core CPU can be multiplied by the current maximum number of cores and then multiplied by 70%-85%

Thread_concurrency = 16

# It is dedicated to the cache of specific SQL statements. If the submitted query is the same as a query that exists in the query cache, the results in the cache are directly returned.

Query_cache_size = 64 M

# Corresponding to the previous setting, when the query result exceeds the size set below, it will not be interesting to the cache area set above, avoiding a large result occupying a large amount of cache.

Query_cache_limit = 2 M

# Set the Minimum word length in full-text search.

# Ft_min_word_len = 4

# The default TABLE Type of the create table statement. If the type is not specified, the downstream type is used.

Default-storage-engine = InnoDB

# The thread stack size. mysql says its own stack size cannot exceed 64 KB. this value can be appropriately set to a higher value (in my projects, it is shared with the same database connection). The default value is 192 KB.

Thread_stack = 800 K

# Set the level of transaction processing, the default REPEATABLE-READ, generally use it, the following two rows correspond in order,

# You can read and write uncommitted data, create uncommitted data copies for read and write, read and write before submission, and only allow serial sequence Zhaoxing transactions.

# READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE

Transaction_isolation = REPEATABLE-READ

# The size of a single memory temporary table in the memory. If this value is exceeded, the table is automatically converted to the disk.

Tmp_table_size = 64 M

# Enable the binary log function to restore the latest backup at a time point

# Log-bin = mysql-bin

# Binary log format, followed by the previous one.-mixed format is recommended.

# Binlog_format = mixed

# Convert query to slow Query

Slow_query_log

# Corresponds to the previous query. If a query exceeds the time set for the next query, the previous query is executed.

Long_query_time = 2

# Custom host ID Identifier for master-slave or multi-server identification. It is an int type.

Server-id = 1

# It is generally used to cache the primary key of the MyISAM table and also used to cache the primary key of the temporary disk table. The temporary disk table appears many times above, so it is best to set a large value for it even if MyISAM is not used, default 32 M

Key_buffer_size = 64 M

# Cache for full table scan of MyISAM table. Each thread has the downstream size.

Read_buffer_size = 2 M

# Cache between the sorting operation and the disk to each thread. The default value is 16 Mb.

Read_rnd_buffer_size = 24 M

# MyISAM cache when using a special tree for batch insert, such as insert... Values ()()()

Bulk_insert_buffer_size = 64 M

# Maximum limit of MyISAM index file,

Myisam_max_sort_file_size = 10G

[1] [2]