Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. Do not query these tables on a production system unless you are aware of the performance impact and ...The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_BUFFER%'; +-----------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_BUFFER%) | +-----------------------------------------------+ | INNODB_BUFFER_PAGE_LRU | | INNODB_BUFFER_PAGE | | INNODB_BUFFER_POOL_STATS | +-----------------------------------------------+ Table Overview INNODB_BUFFER_PAGE: Holds information about each page in the InnoDB buffer ...
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. The implementation comprises these elements: Keyring components and plugins that manage a backing store ...These keyring components are available: component_keyring_file: Stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tde.html
Start the management server with either --initial or --reload to cause it to read the updated configuration file. When you supply the password on the command line, a warning is shown, similar to this one: > ndbmtd -c 127.0.0.1 ... The following ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
For another MySQL extension to standard SQL—that either inserts or updates—see Section 15.2.7.2, “INSERT ... When modifying an existing table that is not partitioned to accommodate partitioning, or, when modifying the partitioning of an ...The ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). As an alternative to ... You ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
If you know the root password and want to change it, see Section 15.7.1.1, “ALTER USER Statement”, and Section 15.7.1.10, “SET PASSWORD Statement”. The following sections provide instructions for Windows and Unix and Unix-like systems, as ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/refman/8.4/en/transport-protocols.html
For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. This section describes how to ...Otherwise, a connection to localhost results in a TCP/IP connection to ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica.html
MySQL Enterprise Backup allows you to set up a replica server (referred to as the “replica” below) by backing up the source server (referred to as the “source” below) and restoring the backup on a new replica, without having to stop the ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-terminology.html
Therefore, you should understand that anytime we use the term host, we are referring to a host computer in both of the senses just given. This section provides definitions of key terms used to describe MySQL Cluster Manager and its components in ...