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/myisam-repair.html
Stage 2: Easy safe repair First, try myisamchk -r -q tbl_name (-r -q means “quick recovery mode”). Safe recovery mode uses an old recovery method that handles a few cases that regular recovery mode does not (but is slower). If the mysqld server ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
Along with the change in MySQL 8.0.16 that enables runtime changes to the TLS context-related system variables, the server enables runtime updates to the actual TLS context used for new connections. This enables you to make any changes required to ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
binlog_row_value_options: Enables binary logging of partial JSON updates for row-based replication. binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row. Options and Variables ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
Deleting it puts all SQL nodes in read-only mode; in NDB 8.0.24 and later, NDB detects that this table has been dropped, and re-creates it, after which it is possible once again to perform updates. This keeps the source mysqld process updated to ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
--auto-generate-sql-load-type=type Command-Line Format --auto-generate-sql-load-type=type Type Enumeration Default Value mixed Valid Values readwritekeyupdatemixed Specify the test load type. The permissible values are read (scan tables), write ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
enforce_gtid_consistency: Prevents execution of statements that cannot be logged in transactionally safe manner. gtid_mode: Controls whether GTID based logging is enabled and what type of transactions logs can contain. relay_log_recovery: Whether ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For other types, inverse aggregation is safe; this includes DECIMAL, which permits a fractional part but is an exact-value type. For faster execution, MySQL always uses inverse aggregation when it is safe: For floating-point values, inverse ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
Changing to Single-Primary Mode Use the group_replication_switch_to_single_primary_mode() function to change a group running in multi-primary mode to single-primary mode by issuing: SELECT group_replication_switch_to_single_primary_mode() When you ... This section explains how to change the mode which a group is running in, either single or ...If you do not ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL 8.0.34). If these tables are missing, the audit_log plugin operates in (deprecated) legacy mode. Example: mysql> SELECT ...Audit Log Tables MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-single-user-mode.html
Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL server (SQL node) or an instance of ndb_restore. When entering single user mode, connections to all other API nodes ...You can also check the status column of the ndbinfo.nodes table (see Section 25.6.16.47, “The ndbinfo nodes Table”, for more ...