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/data-directory-initialization.html
For example, you might see an error like this: bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory If this happens, you must install the missing libraries manually or with your ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/data-masking.html
MySQL Enterprise Edition provides data masking and de-identification capabilities: Transformation of existing data to mask it and remove identifying characteristics, such as changing all digits of a credit card number but the last four to 'X' ...A ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/mysqlbinlog.html
When you specify this option, mysqlbinlog stops with an error message if it encounters any events that are disallowed under the REQUIRE_ROW_FORMAT restrictions, including LOAD DATA INFILE instructions, creating or dropping temporary tables, INTVAR, ... The server's binary log consists of files containing “events” that describe modifications to database ...You can also use mysqlbinlog to display the contents of relay log ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
Does data remain encrypted on the network? Data encrypted by the InnoDB data-at-rest feature is decrypted when it is read from the tablespace file. What are the encryption algorithms used with InnoDB data-at-rest encryption? A.17.4. Is it possible ...What data types and data lengths does InnoDB data-at-rest encryption support? ...According to ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
To minimize space even further by storing table data in compressed form, specify ROW_FORMAT=COMPRESSED when creating InnoDB tables, or run the myisampack command on an existing MyISAM table. This can result in huge improvements by reducing the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-understanding-innodb-locking.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. (The INFORMATION_SCHEMA ...A ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-schema.html
When --no-dd-upgrade is specified, and the server finds that the data dictionary version of the server is different from the version stored in the data dictionary, startup fails with an error stating that the data dictionary upgrade is prohibited.
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
If (despite this warning) you run multiple servers using the same data directory and they have logging enabled, you must use the appropriate options to specify log file names that are unique to each server. Modify the new option file so that any ...