MARIADB MY.CNF Detailed

#/usr/share/mysql/my-huge.cnf # mariadb configuration File Sample template (huge, mega). 
# # This file applies to the dedicated database server, memory for 1G-2G # machines mostly only run mariadb large systems, # # MARIADB programs will look up a series of profiles based on the operating system platform, # You can copy this template profile to a corresponding location (and rename it), # to see which profiles will be read, execute: # ' My_print_defaults--help ' and view # Default options are read from the following files in the given O
Rder: # (the--> program reads the listed configuration files sequentially.) The list of files (paths) listed below in this section.
# For more information please refer to: http://dev.mysql.com/doc/mysql/en/option-files.html # # In each section of this document, you can use all the options supported by the program.

# If you want to know whether a program supports a parameter, # you can use the '--help ' option to start the program to view help information.

# The configuration options in the following section are read by all local MySQL clients, as the default configuration [client] #password = your_password Port = 3306 Socket =/var/lib/mysql/mysql.sock # The following sections, which are read by various applications to parse # MySQL server configuration information [mysqld] port = 3306 Socket =/var/lib/mysql/mysql.sock Skip-external-locki ng key_buffer_size = 384M Max_allowed_packet = 1M Table_open_cache = sort_buffer_size = 2M read_buffer_size = 2M Read_ Rnd_buffer_size = 8M Myisam_sort_buffer_size = 64M Thread_cache_size = 8 query_cache_size = 32M # Concurrent threads number, recommended for CPU core multiplied by 2:cpu ' S*2 For thread_concurrency thread_concurrency = 8 # You can specify a path to a dedicated disk as a temporary directory, such as SSD #tmpdir =/tmp/# Configure this parameter to not start TCP/IP port sniffing.
# If all the handlers are connected to mysqld on the same machine, this is a safe practice, # All interactions with mysqld can only be done through UNIX sockets or named pipes (named pipes).
# Note that using this option does not open a named pipe on Windows (Named Pipes), # (through the "enable-named-pipe" configuration item) will cause MYSQLD to be unavailable!  #skip-networking # master server configuration Option Replication master server (default) # in master-slave replication, you need to rely on binary log Log-bin=mysql-bin # in the entire master-slave replication cluster requires 1 to
Unique ID between 2^32-1, otherwise or failed, or a large number of error log information.
# If Master-host is not set, the default value is 1 # but if omitted, (master) does not take effect Server-id = 1 # from server configuration options Replication Slave (you need to comment out the master section to use this section) # # To configure the server as a secondary server (replication slave), # There are two options available: # # 1 through the Change MASTER to command (detailed description in the user's manual)-# The syntax is as follows: # CHA NGE MASTER to Master_host=