Search Results
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
If long updating statements are running when the FLUSH statement is issued, the backup operation may stall until those statements finish. While the server is running, you can also tell it to close the current binary log file and begin a new one ...A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
Such a key takes up space just as does any other table index. Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbdictionary.html
This section provides information about the NdbDictionary class, which stores meta-information about NDB database objects, such as tables, columns, and indexes. NdbDictionary Class Overview NdbDictionary::AutoGrowSpecification ...While the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage engine. The index key prefix length limit is 3072 bytes for InnoDB tables that use DYNAMIC or COMPRESSED row format. The index key prefix ...ERROR 1070 (42000): Too many key parts specified; max 16 parts allowed The maximum row size, excluding any variable-length columns that are stored off-page, is slightly less than half of a page for 4KB, 8KB, 16KB, and 32KB page ...
https://dev.mysql.com/doc/refman/8.4/en/online-ddl-parallel-thread-configuration.html
The actual number of threads that scan the clustered index is the number defined by the innodb_parallel_read_threads setting or the number of index subtrees to scan, whichever is smaller. The following limitations apply: Parallel threads are not ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
row *************************** NAME: statement/abstract/Query ENABLED: YES TIMED: YES PROPERTIES: mutable FLAGS: NULL VOLATILITY: 0 DOCUMENTATION: SQL query just received from the network. At this point, the real statement type is unknown, the type ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
If str_col is an indexed string column, the index cannot be used when performing the lookup in the following statement: SELECT * FROM tbl_name WHERE str_col=1; The reason for this is that there are many different strings that may convert to the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
If a table containing full-text search (FTS) index is backed up using transportable tablespace (TTS), after it is restored, the FTS index will be corrupted. Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-maintenance.html
This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). Other table-repair information can be found at Section 3.14, “Rebuilding or Repairing Tables or ...