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/ndb-restore-to-different-version.html
In such cases, it is necessary to alter any tables using utf8mb4_ai_ci so that they use a character set supported in the older version prior to performing the backup. Due to changes in how the MySQL Server and NDB handle table metadata, tables ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
Even with additional write costs, secondary indexes on virtual columns may be preferable to generated stored columns, which are materialized in the clustered index, resulting in larger tables that require more disk space and memory. row ...A ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-server-locks.html
The server_locks table is similar in structure to the cluster_locks table, and provides a subset of the information found in the latter table, but which is specific to the SQL node (MySQL server) where it resides. (The cluster_locks table provides ...This may be useful for correlating locking patterns with specific MySQL user sessions, queries, or use ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or Problems”. If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production ...To avoid impacting performance on a production system, reproduce the issue you want to investigate and query buffer pool statistics on a test ...
https://dev.mysql.com/doc/refman/8.0/en/nested-join-optimization.html
The syntax of table_factor is extended in comparison with the SQL Standard. The latter accepts only table_reference, not a list of them inside a pair of parentheses. This is a conservative extension if we consider each comma in a list of ...The ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
Alternatively, the INSTALL PLUGIN statement causes the server to load the plugin code from the library file at runtime: INSTALL PLUGIN myplugin SONAME 'somepluglib.so'; INSTALL PLUGIN also causes “permanent” plugin registration: The plugin is ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...For ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
When modifying an existing table that is not partitioned to accommodate partitioning, or, when modifying the partitioning of an already partitioned table, you may consider altering the table's primary key (see Section 26.6.1, “Partitioning Keys, ...| TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
Note that from MySQL 8.0.14, mysqlbinlog returns a suitable error if you attempt to read an encrypted binary log file directly, but older versions of mysqlbinlog do not recognise the file as a binary log file at all. The other option values are ...