PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-firewall-tables.html
They provide information about firewall operation: firewall_groups: Information about firewall group profiles. Note The Performance Schema tables described here are available as of MySQL 8.0.23. Prior to MySQL 8.0.23, use the corresponding ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables. These do not fall into any of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within the table. The xxx_WAIT columns of the tp_thread_group_stats table accumulate counts for each wait ...
https://dev.mysql.com/doc/refman/8.0/en/programs-development.html
This section describes some utilities that you may find useful when developing MySQL programs. In shell scripts, you can use the my_print_defaults program to parse option files and see what options would be used by a given program. This works well ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
However, as of MySQL 8.0.13, the optimizer can perform multiple range scans, one for each value of f1, using a method called Skip Scan that is similar to Loose Index Scan (see Section 10.2.1.17, “GROUP BY Optimization”): Skip between distinct ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules.html
Note that replication filters cannot be used on Group Replication-specific channels on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync.html
If your goal is to implement a fault-tolerant replication topology where all the servers receive the same transactions in the same order, and a server that crashes can rejoin the group and be brought up to date automatically, you can use Group ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
If there is no pending resize down operation, Innodb_redo_log_capacity_resized should be equal to the innodb_redo_log_capacity setting if it's used, or it's ((innodb_log_files_in_group * innodb_log_file_size)) if those are used instead. On some ...