Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. If you wish to make such information hidden from queries that ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
A server restart or the first opening of the mysql.index_stats and mysql.innodb_table_stats tables do not update cached statistics automatically. When the server is in read_only, super_read_only, transaction_read_only, or innodb_read_only mode. To ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
Because checksum mismatches cause InnoDB to deliberately shut down a running server, it may be preferable to use this tool rather than waiting for an in-production server to encounter the damaged pages. innochecksum cannot be used on tablespace ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Cold Backups If you can shut down the MySQL server, you can make a physical backup that consists of all files ... The key to safe database management is making regular ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
You can configure InnoDB buffer pool size offline or while the server is running. Configuring InnoDB Buffer Pool Size Online The innodb_buffer_pool_size configuration option can be set dynamically using a SET statement, allowing you to resize the ...For additional information about configuring buffer pool size online, see Configuring InnoDB Buffer Pool Size ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting.html
The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server error log (see Section 7.4.2, “The Error Log”). Server Error Message Reference provides ...If the ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-brokers.html
After configuring your server host to use a broker-supplied IPv6 address, start the MySQL server with an appropriate bind_address setting to permit the server to accept IPv6 connections. You can specify * (or ::) as the bind_address value, or bind ... If you do not have a public IPv6 address that enables your system to communicate over IPv6 outside your local network, you can obtain one from an IPv6 ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
When the server later must read a JSON value stored in this binary format, the value need not be parsed from a text representation. The binary format is structured to enable the server to look up subobjects or nested values directly by key or array ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. These keyring components are available: component_keyring_file: Stores keyring data in a file local to ...The implementation comprises these elements: Keyring components and plugins that manage a backing store or communicate with a storage back ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
With statement-based binary logging, the source server writes the executed queries to the binary log. Log file names are based on the server host name if you do not specify a file name with the startup option. The server uses only the first ... This ...