Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
For example: [mysqld] innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend The autoextend and max attributes can be used only for the data file that is specified last. The following configuration permits ibdata1 to grow to a limit of 500MB: ...
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 ...ERROR ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
ibdata file A set of files with names such as ibdata1, ibdata2, and so on, that make up the InnoDB system tablespace. If innodb_temp_data_file_path is not specified, the default behavior is to create a single auto-extending 12MB data file named ...C ...Instead of flushing all modified pages from the buffer pool to the data files at once, MySQL periodically flushes small sets of modified ...Experienced users can adjust the isolation level, trading off less ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
Input File Location These rules determine the LOAD DATA input file location: If LOCAL is not specified, the file must be located on the server host. INTO OUTFILE in tandem with LOAD DATA to write data from a database into a file and then read the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-secretsfile-reader.html
Usage ndb_secretsfile_reader options file The options must include one of --filesystem-password or --filesystem-password-from-stdin, and the encryption password must be supplied, as shown here: > ndb_secretsfile_reader --filesystem-password=54kl14 ... ndb_secretsfile_reader gets the encryption key from an NDB encryption secrets file, given the ...--defaults-extra-file Command-Line Format ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
Cannot Open Datafile With innodb_file_per_table enabled (the default), the following messages may appear at startup if a file-per-table tablespace file (.ibd file) is missing: [ERROR] InnoDB: Operating system error number 2 in a file operation. If ...See Section 17.6.1.4, “Moving or Copying InnoDB Tables” for information about creating clean ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-internal-data.html
The data exposed by the transaction and locking tables (INFORMATION_SCHEMA INNODB_TRX table, Performance Schema data_locks and data_lock_waits tables) represents a glimpse into fast-changing data. The underlying data is internal system-managed ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-innodb-redo-log-files-table.html
The innodb_redo_log_files table contains a row for each active InnoDB redo log file. The innodb_redo_log_files table has the following columns: FILE_ID The ID of the redo log file. SIZE_IN_BYTES The size of the redo log data in the file, in bytes.
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-defragmenting.html
All InnoDB data and indexes are stored in B-trees, and their fill factor may vary from 50% to 100%. If the insertions into an index are always ascending and records are deleted only from the end, the InnoDB filespace management algorithm guarantees ...To speed up index scans, you can periodically perform a “null” ALTER TABLE operation, which causes MySQL to rebuild the table: ALTER TABLE tbl_name ENGINE=INNODB You can also use ALTER TABLE tbl_name FORCE to perform a “null” alter operation that rebuilds the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
You must also specify at least one data file; you can add more data files to the tablespace after the tablespace is created. A log file group, a tablespace, and any Disk Data tables using these must be created in a particular order. Undo log files ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...