Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/cpu-utilization-advisor-ref.html
Small Group Notification: Whether or not to generate an event if the sample size is too small to enable outlier detection. Minimum Server Count for Outlier Detection: Minimum required sample size before outlier detection is enabled. Monitors and ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-flow-control.html
The replication protocol provides a mechanism to avoid having too much distance, in terms of transactions applied, between fast and slow members. Whenever the size of one of these queues exceeds the user-defined threshold, the throttling mechanism ... MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. To begin, you should have a ...The ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
thread_stack_size Type Integer Default Value 64 Minimum Value 1 Maximum Value 65535 The stack size allocated for each thread. [DEFAULT] thread_stack_size=128 net_buffer_length Type Integer Sets the net_buffer_length MySQL server option. Blocked ...
https://dev.mysql.com/doc/internals/en/x-protocol-use-cases-use-cases.html
Streaming Inserts When inserting a large set of data (data import), make a trade-off among: memory usage on client and server side network round-trips error reporting For this example it is assumed that 1 million rows, each 1024 bytes in size have ...Optimizing for Network Round-Trips (Assuming the MySQL Client/Server Protocol in this case) Network round-trips can be minimized by creating a huge SQL statements of up to 1Gbyte in chunks of 16Mbyte (the protocol's maximum frame size) and sending it over the wire and letting the server execute ... Topics in this section: Prepared Statements with Single Round-Trip Streaming ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
For InnoDB tables, the row count is only a rough estimate used in SQL optimization. (This is also true if the InnoDB table is partitioned.) AVG_ROW_LENGTH The average row length. Specifically, it is the clustered index size, in pages, multiplied by ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/internals/en/innodb-field-start-offsets.html
There are two complications for special cases: Complication #1: The size of each offset can be either one byte or two bytes. One-byte offsets are only usable if the total record size is less than 127. There is a flag in the "Extra Bytes" part which ... The Field Start Offsets is a list in which each entry is the position, relative to the Origin, of the start of the next ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbfulltext-category.html
Cache Size Size of the cache that holds a parsed document in memory while creating an InnoDB FULLTEXT index. Max Token Size Maximum length of words that are stored in an InnoDB FULLTEXT index. Min Token Size Minimum length of words that are stored ... Lists the InnoDB Fulltext configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-doublewrite-buffer.html
Data is written to the doublewrite buffer in a large sequential chunk, with a single fsync() call to the operating system (except in the case that innodb_flush_method is set to O_DIRECT_NO_FSYNC). The default size of a flush list doublewrite file is ... The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before writing the pages to their proper positions in the InnoDB data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-multiple-buffer-pools.html
This feature is typically intended for systems with a buffer pool size in the multi-gigabyte range. Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the ... For ...