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-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/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. A floating-point value as written in an SQL statement may not be the same as the value represented internally. Attempts to treat ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION. ONLY_FULL_GROUP_BY Reject queries for which ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.0/en/sql-replication-statements.html
Statements are split into a group which controls source servers, a group which controls replica servers, and a group which can be applied to any replication servers. Replication can be controlled through the SQL interface using the statements ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
The optional third parameter enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between separators. If the last group is incomplete, it is padded with '=' characters to a length of 4.