PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-group-membership.html
In MySQL Group Replication, a set of servers forms a replication group. The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. Every server in the group has a consistent view of which servers are ...A group has a name, which takes the form of a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-flushing.html
Limiting Buffer Flushing During Idle Periods As of MySQL 8.0.18, you can use the innodb_idle_flush_pct variable to limit the rate of buffer pool flushing during idle periods, which are periods of time that database pages are not modified. In MySQL ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. Information available in this table provides a real-time snapshot of the active connections to the server. Wait times for active sockets are ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query optimizers, including that of MySQL, perform a more or less exhaustive search for an ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. See Section 17.16, “InnoDB Integration with MySQL Performance ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Otherwise, MySQL locks the table during the time OPTIMIZE TABLE is running. To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-stats-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA table instead; see Section 28.5.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”. The ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
Beginning with MySQL 8.0.22, a parameter used in a prepared statement has its type determined when the statement is first prepared, and retains this type whenever EXECUTE is invoked for this prepared statement (unless the statement is reprepared, as ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html
Note As of MySQL 8.0.22, an alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, like the threads table, does not require a mutex and has better performance characteristics. Time ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-thread_concurrency.html
In situations where it is helpful to minimize context switching between threads, InnoDB can use a number of techniques to limit the number of concurrently executing operating system threads (and thus the number of requests that are processed at any ... InnoDB uses operating system threads to process requests from user ...