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/clone-plugin-failure-handling.html
If the operation does not resume within the allotted time, it aborts and returns an error, and the donor drops the snapshot. Prior to MySQL 8.0.24, donor threads use the MySQL Server wait_timeout setting when listening for Clone protocol commands.
https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html
Supported Platforms Page compression requires sparse file and hole punching support. For example, if innodb_page_size=16K and the file system block size is 4K, page data must compress to less than or equal to 12K to make hole punching possible. Hole ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
Since sql_generate_invisible_primary_key was OFF at the time that auto_0 was created, no such additions were performed on that table. When a primary key is added to a table by the server, the column and key name is always my_row_id. When GIPKs are ... Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created without an explicit primary ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-destination-configuration.html
This is your terminal or console window unless the standard error output has been redirected to a different destination. The server interprets options that determine the default error log destination somewhat differently for Windows and Unix systems. (--console takes precedence over --log-error if both are given, and the following items regarding --log-error do not apply.) If --log-error is not given, or is given without naming a file, the default destination is a file named host_name.err in the data directory, unless the --pid-file option is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
With foreign keys, inserts, updates, and deletes are checked to ensure they do not result in inconsistencies across related tables. InnoDB is a general-purpose storage engine that balances high reliability and high performance. Key Advantages of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
Other mutexes have an instance per connection, or per page in various caches and data buffers, so the number of instances varies over time. If the value chosen for performance_schema_max_mutex_classes is too small, no error is reported in the error ...Performance_schema_xxx_handles_lost indicates how many instances of object type xxx could not be ...Names for these variables have several ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-disable-gtids.html
You cannot disable GTID transactions if this option is set together with the --log-slave-updates option (which is the default) and binary logging is enabled (which is also the default). This procedure does not require taking the server offline and ... This section describes how to disable GTID transactions on servers that are already ...
https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html
Many system variables are dynamic and can be changed at runtime by using the SET statement. For a description of the privilege requirements for setting and persisting system variables, see Section 7.1.9.1, “System Variable Privileges” Suffixes ...System variables can be set at server startup using options on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. Window functions are permitted only in the select list and ORDER BY clause. Query result ...
https://dev.mysql.com/doc/refman/8.0/en/server-loadable-functions.html
See Section 7.6.4, “The Rewriter Query Rewrite Plugin” Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. The following sections describe how ... MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove ...