Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
Table 1.1 Types of Files in a Backup File Name, Pattern, or Extension Relation to Original Data Files Notes ibdata* The InnoDB system tablespace, containing multiple InnoDB tables and associated indexes. *.ibz Compressed form of InnoDB data files ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
If you find the text mysqld restarted in the error log (normally a file named host_name.err) you probably have found a query that causes mysqld to fail. When the server detects MyISAM table corruption, it writes additional information to the error ...When mysqld dies again, you can examine the end of the log file for the query that killed ... Note that before ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
The local file looks like this: { "path": "/usr/local/mysql/keyring/component_keyring_encrypted_file", "password": "password", "read_only": false } This path must not point to or include the MySQL data directory. The component_keyring_encrypted_file ...Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components are not intended as a regulatory compliance ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-file-component.html
The local file looks like this: { "path": "/usr/local/mysql/keyring/component_keyring_file", "read_only": false } This path must not point to or include the MySQL data directory. The component_keyring_file keyring component stores keyring data in a ...Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components are not intended as a regulatory compliance ...Security standards ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
Important Although MySQL Configurator places most files under PROGRAMDIR, it installs my.ini under the C:\ProgramData\MySQL\MySQL Server 8.4\ directory by default. As used to find mysqld-auto.cnf, its default value is the data directory location ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. InnoDB tables use a clustered index, which makes it relatively fast to use ...When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every ... These ...To ...
https://dev.mysql.com/doc/refman/8.4/en/error-creating-innodb.html
Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the following solutions: Make sure the InnoDB data file directory and the InnoDB log directory exist. In particular, any MAX value in ...If you created any InnoDB tables, also delete any .ibd files from the MySQL database ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-database-file-io.html
Table 5.6 InnoDB File I/O Performance Page Regions NameDescriptionData File IO Activity (bytes) Graphs the amount of data read and written, in bytes. Table 5.2 Database File I/O By Host NameDescription Host The host from which the client connected.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/config-file-parameters.html
# [mysqld] innodb_data_file_path=ibdata1:12M:autoextend innodb_page_size=16384 innodb_checksum_algorithm=crc32 innodb_buffer_pool_filename=ib_buffer_pool innodb_undo_tablespaces=2 All file paths contained in the generated backup-my.cnf are relative ...Only the minimally-required parameters are stored in backup-my.cnf: for example, the innodb_data_home_dir and innodb_log_group_home_dir options are omitted from the backup-my.cnf file when they just point to the data directory under the backup directory (backup-dir/datadir ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Example: <STARTUP_OPTIONS>/usr/local/mysql/bin/mysqld --port=3306 --log_output=FILE</STARTUP_OPTIONS> <STATUS> An unsigned integer representing the command status: 0 for success, nonzero if an error occurred. Example: STARTUP_OPTIONS="--port=3306 ...