Search Results
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
The flush is needed to ensure that the all active index pages are written to disk before you start the backup. See Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”, and Section 15.7.8.3, “FLUSH Statement”. Also, even if the server ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
Example: ALTER TABLE trb3 CHECK PARTITION p1; This statement tells you whether the data or indexes in partition p1 of table t1 are corrupted. A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
Obtained the source status information, or a copy of the source's binary log index file made during a shutdown for the data snapshot. Execute a CHANGE REPLICATION SOURCE TO statement on the replica to set the source configuration. Alternatively, you ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
row *************************** Name: t1 Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2021-02-18 12:18:28 Update_time: ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/server-plugin-descriptors.html
This is the name that will be listed in the mysql.plugin table and by which you refer to the plugin in SQL statements such as INSTALL PLUGIN and UNINSTALL PLUGIN, or with the --plugin-load option. When the plugin is installed, these variables are ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexscanoperation.html
NdbIndexScanOperation Class Overview NdbIndexScanOperation::BoundType NdbIndexScanOperation::end_of_bound() NdbIndexScanOperation::getDescending() NdbIndexScanOperation::get_range_no() NdbIndexScanOperation::getSorted() ...Description This type is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
To write queries for these tables most efficiently, take advantage of their indexes. For example, include a WHERE clause that restricts retrieved rows based on comparison to specific values in an indexed column. Performance Schema indexes give the ... Applications that monitor databases may make frequent use of Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-issues.html
For the cases when MySQL does not do the "right" thing, tools that you have available to help MySQL are: Use the EXPLAIN statement to get information about how MySQL processes a query. To use it, just add the keyword EXPLAIN to the front of your ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
For all character data types (CHAR, VARCHAR, and the TEXT types), the maximum number of characters that can be indexed is less for utf8mb4 columns than for utf8mb3 columns. Consequently, to convert tables from utf8mb3 to utf8mb4, it may be necessary ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
IS_HASHED Whether a hash index has been built on this page. This column is applicable only to pages with a PAGE_TYPE value of INDEX. This can be the name of a clustered index or a secondary index. This column is applicable only to pages with a ...