Shulou(Shulou.com)06/03 Report--

1:binlog_group_commit_sync_delay

Global dynamic variable, unit subtle, default 0, range: 0cm 1000000 (1 second).

Indicates how long it takes to wait for binlog to be submitted before synchronizing to disk. Default is 0, and there is no delay. Setting delay allows multiple transactions to commit at one time, improving the concurrency and efficiency of binlog group commits, and improving the throughput of slave.

2:binlog_group_commit_sync_no_delay_count

Global dynamic variable, number of units, default 0, range: 0mm 1000000.

Indicates the maximum number of transactions waiting for delayed commit. If the time for the above parameter is not up, but the number of transactions has arrived, it will be synchronized directly to disk. If binlog_group_commit_sync_delay is not enabled, this parameter will not be enabled.

3:check_proxy_users

Global dynamic variable, off by default.

Indicates whether to enable the proxy user function, which will be described later in the security section.

4VRV defaultauthenticationauthenticationpluginMurbe-Security

Global variable. Default mysql_native_password. Optional: sha256_password.

Indicates the user's default authentication method, that is, the encryption method, which will be described later in security.

5VRV defaultPasswordPassage lifetime TV-Security

Global dynamic variable, default 0, range: 0mm 65535, unit day.

Indicates the expiration time of the user's password, which is turned off by default. A setting of 365 indicates that the user's password expires after one year.

6:disabled_storage_engines

Global variable, default empty.

Forbids the creation of the specified storage engine, such as disabled_storage_engines= "MyISAM,FEDERATED". If the server starts to enable-- bootstrap,-- initialize,--initialize-insecure,-- skip-grant-tables parameters, disabled_storage_engines will not work.

7Ru gtidholders executedperformanceships-performance

Global dynamic variable, default 1000, range: 0such 4294967295

Indicates that the mysql.gtid_ executed table is compressed for each number of transactions executed, with a default value of 1000.

8HAVESTATIONMETHAID timeout color-performance

Global variable, default YES

Indicates whether the statement execution timeout function is available, which is enabled by default.

9Rose innodency adaptivehashworthy indexation partsMutual-performance

Global variable, default 8, range 1 to 512.

Indicates that adaptive hash indexing begins to support partitioning to avoid lock contention problems caused by a single index, which is divided into 8 by default. The maximum setting is 512.

10 Rose innodency bufferless pooling chunkproof sizeMuir-performance

Global variable, default 128m, range: 1M~innodb_buffer_pool_size / innodb_buffer_pool_instances

In order to support online buffer pool resize, the concept of chunk is introduced. Each chunk defaults to 128m. When we modify buffer pool online, we grow or contract in terms of chunk. Innodb requires that buffer pool size be a multiple of innodb_buffer_pool_chunk_size* innodb_buffer_pool_instances, and if not, innodb_buffer_pool_size will be appropriately enlarged to meet the requirements, so it is possible that the actual allocation of buffer pool is larger than the size specified in the configuration file.

11:innodb_buffer_pool_dump_pct

Global dynamic variable, starting with 5.7.7, the default is 25 (percentage), compared with 100 (percentage) before. Range: 1mm 100 (percentage)

Indicates that the percentage of backup buffer pool is controlled. For more information about BP prefetch, please see this article.

12Rom innodency defaultmatching rowformat color-performance

Global dynamic variables. DYNAMIC is the default after 5.7.9, and COMPACT is the default before. Available values are: DYNAMIC, COMPACT, REDUNDANT. COMPRESSED is not supported by system tablespaces, but regular tables can be created. You can view the row format of the table through show table status like 'tb'. Indicates that the default ROW_FORMAT is specified. You can read this article about the various line formats of innodb.

13:innodb_fill_factor

Global dynamic variables. Default 100, range: 10: 100

Represents the percentage of tablespaces for each b-tree page during the construction of the sorted index, leaving the remaining space for future exponential growth. That is, when the fill ratio of the page is considered to be full. If set to 100, a space of 1DB 16 is set aside on the page for future growth. Just like a 16K page in innodb, 15K will be used at most, and the remaining 1K will be used for subsequent table index maintenance. Valid for leaf and non-leaf nodes, but not for overflow lines containing text and blog.

14 _ performance

Global dynamic variable, default is ON

When you are in checkpoint, you will not be affected by innodb_io_capacity.

15Rose innocent database logically checksumsmuri-performance

Global dynamic variable, default ON.

Indicates that before writing a redo log to a file, each block of the redo log needs to be appended with a checksum check bit to prevent the apply from damaging the redo log. CRC-32C is used to check the redo log instead of the less efficient innodb_log_checksum_algorithm.

16Rose innodency logarithmic writeware headset sizelux color-performance

Global dynamic variable, default 8192, that is, 8K, range: 512bytes~innodb_page_size, in bytes.

Represents the block size before redo log is written. InnoDB writes ib_logfile files in an aligned manner of 512 bytes per block, but file systems typically use 4096 bytes as a block unit. If the log file block you are about to write is not in OS Cache, you need to read the corresponding 4096 bytes of block into memory, modify the 512 bytes, and then write the block back to disk. This parameter solves this problem. When the offset currently written to the file cannot be divisible by this value, it will fill in 0 and write more data. In this way, when the written data is aligned with the disk block size, you can directly write the disk without the three steps of read-modify-write.

17Rom innodDB maxillary undotted logcolors sizemuri-performance

Global dynamic variable, default 1073741824byte is 1024m, range: 10M~2**64-1byte

Indicates the maximum value of the limit undo log. If the threshold is exceeded, undo will be marked as truncate when innodb_undo_log_truncate is enabled. You can enable online shrinking undo logs, but you need to enable parameters innodb_undo_tablespaces and innodb_undo_directory. See this article for more information about the log.

18Rom innodency pagehands cleaners-performance

Global variable, default before 5.7.7, default 1, after 5.7.8, default 4, range: 1century 64

Indicates the number of threads brushing dirty BP pages, 5.6.2 is independent from master threads, and 5.7.4 supports multithreaded flush. This value must be less than or equal to innodb_buffer_pool_instances.

19Rom innocent database purgeable rsegmented truncated music-performance

Global dynamic variable, default 128, range: 1: 128

Indicates that the speed of the rollback segment of the purge is controlled, and cannot be recycled when the undo table space has an active segment on it. This parameter sets the number of times the purge is executed, the purge rolls back the segment once.

20:innodb_temp_data_file_path

Global variable, default ibtmp1:12M:autoextend. Generate a file with an ibtmp1 size of 12m under the data directory.

Represents the path, file name, and size of the specified innodb temporary tablespace file. All uncompressed temporary tables use the same temporary tablespace, and compressed temporary tables use separate data files for each table in the directory specified by tmpdir. You can view more information at INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO.

21Rom innocent database undotted logically truncated color-performance

Global dynamic variable, default OFF.

Indicates whether online shrinking undo log is enabled. When undo log exceeds the size defined by innodb_max_undo_log_size, undo is marked as truncate. It works only for separations with undo log turned on, not for undo log with shared tablespaces. You need to set parameters innodb_undo_tablespaces (> = 2) and innodb_undo_logs (> = 35) and innodb_undo_directory

22:internal_tmp_disk_storage_engine

Global dynamic variable, default INNODB

Indicates the storage engine used for temporary tables of internal disks. After 5.7.6, the default is innodb. Available values include: innodb, myisam.

23:log_builtin_as_identified_by_password

Global dynamic variable, default OFF

24Rom logarithmic errorless verbosityMutual-performance

Global dynamic variable, default 3, range: 1-3

Represents the information recorded in the error log, 1: record only error information; 2: record error and warnings information; 3: record error, warnings, and normal notes information.

25bloggers statementsperformances unscheduled performances for performance binloghouse-performance

Global dynamic variable, default ON.

Indicates whether the error code '1592' information is recorded in the error log. Error code' 1592':Unsafe statement written to the binary log using statement format

26Logistic syslogMurray-performance

Global dynamic variable, default OFF

Indicates whether error logs are logged to syslog (/ var/log/syslog).

27:log_syslog_facility

Global dynamic variable, default daemon.

Indicates that the device error number is written to syslog, provided that the log_syslog parameter is enabled.

28:log_syslog_include_pid

Global dynamic variable, default ON.

Indicates whether to write the id of the service process to syslog, provided that the log_syslog parameter is enabled.

29:log_syslog_tag

Global dynamic variable, default empty.

Indicates that the label is added to the server identifier and written to the syslog in the error log

30:log_timestamps

Global dynamic variable. Default UTC. Available values: UTC, SYSTEM.

Indicates that this variable controls when log messages are written to the file, including error logs, normal logs, and slow query logs.

31:max_execution_time

Global\ session dynamic variable, default 0.

Indicates the timeout for executing the select statement. The default is 0: no timeout.

32:mysql_native_password_proxy_users

Global dynamic variable, default OFF.

Indicates whether the plug-in that controls the built-in authentication of the agent user is supported, provided that check_proxy_users is enabled and this parameter is introduced in 5.7.7.

33:ngram_token_size

Global variable, default 2. Range: 1: 10

For more information, please see InnoDB full-text Index: N-gram Parser for more information.

34For offlineweight modewi-performance

Global dynamic variable, default OFF.

Indicates that offline mode (offline mode) has been added to the server layer to facilitate the upgrade and maintenance work of the administrator. Features: after being set to offline mode, the non-SUPER account will be disconnected and reported an error on the next request; the SUPER account can maintain the connection and manage the database; and the standby replication thread will not be interrupted.

35 RangeShakeshizerMaxMemeSzeMui-performance

Global\ session dynamic variable, the default is 8388608 or 8m.

Indicates that the maximum memory usage of the range optimizer is limited. 0 means no limit.

36:rbr_exec_mode

Session dynamic variable. Default STRICT. Available values: STRICT, IDEMPOTENT

Represents the mode that controls session threads: STRICT and IDEMPOTENT. IDEMPOTENT mode ignores duplicate-key and no-key-found errors and is useful for playback in row mode where there is data, by adding the-- idempotent parameter through mysqlbinlog.

37PUBG security security transportMutual-Security

Global dynamic variable, default OFF.

Indicates whether some form of secure transport is required for the client to connect to the server. If enabled, the server only allows TCP/IP connections using SSL, or connection files using a socket. The server rejected an insecure connection attempt and failed to report an error ER_SECURE_TRANSPORT_REQUIRED error. This feature gives priority to SSL requirements. If a REQUIRE SSL account is defined and require_secure_transport is enabled, the account cannot be connected using Unix socket files.

38shasha256secure passwordproxy proxy usersMel-safe

Global dynamic variable, default OFF.

Indicates whether the plug-in that controls the built-in authentication of the agent user is supported, provided that check_proxy_users is enabled and this parameter is introduced in 5.7.7.

39:show_compatibility_56

Global dynamic variable, default OFF after 5.7.8.

It means that information_schema.global_status has been discarded since mysql5.7.6. For compatibility, you need to open show_compatibility_56 at this time, otherwise an error is reported:

ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for' show_compatibility_56'

40 slavehorse parallelism type color-performance

5.7.2 the mode of parallel replication is supported. The default DATABASE, which represents parallel replication at the library level, and LOGICAL_CLOCK: parallel replication based on group commit. Available values: DATABASE, LOGICAL_CLOCK

Represents the mode of multithreaded replication. 5. 6 starts to support database-based parallel replication, which is not effective for those with only one library. Parallel replication based on group commit (LOGICAL_CLOCK) is supported to improve the availability of replication. For more information, see MySQL 5.7 parallel replication implementation principles and tuning

41slavepreserveportable portable instrument-performance

Global dynamic variable, default 0, optional values 0, 1.

Indicates whether the order needs to be strictly maintained, and a default value of 0 indicates that the order is ignored for concurrent execution. For multithreaded slaves, to ensure that the order of transactions executed on slave is strictly the same as that in relay log, only when slave_parallel_workers is enabled, log_bin and log_slave_updates must be enabled, and the slave_parallel_ type value must be LOGICAL_CLOCK (default is DATABASE). If your transactions are often cross-DB operations, you can consider using this parameter to limit the order. When this parameter is on, when any worker thread is required to execute a transaction, it can only be executed and committed after all previous transactions in the current transaction have been executed by other worker threads.

42VAND supervised readreadable onlycolor-safe

Global dynamic variable, default OFF. Parameters supported after 5.7.8.

Before 5.7.8, the read_only parameter is enabled on the server, which means that only accounts with super permission can update or modify tables. Users who do not have super permissions cannot be modified. After 5.7.8, enable the super_read_only parameter, the account with super permission cannot update or modify the table, and the read_only will be invalid (controlled by super_read_only).

43PUBG tlssafe version color-safe

Global variable, default TLSv1,TLSv1.1.

Indicates that connections to the server are allowed to be encrypted, and the value is a comma-separated list of one or more protocol names.

44 _ performance

Global variable, default OFF.

Indicates that the buffer pool memory allocation strategy adopts the interleave method

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.