Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
This repository is created by default as an InnoDB table named mysql.slave_relay_log_info. DML transactions and also atomic DDL update the replication positions in the replica's applier metadata repository in the mysql.slave_relay_log_info table ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
If an application generates a query such as SELECT * FROM table WHERE ID=234 when a user enters the value 234, the user can enter the value 234 OR 1=1 to cause the application to generate the query SELECT * FROM table WHERE ID=234 OR 1=1. As a ...
https://dev.mysql.com/doc/refman/8.4/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily ...The pattern is useful for restricting statement output to matching ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-errors.html
All of the errors described in this section also apply when using TABLE in subqueries. Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
Only statements that modify databases or tables count against the update limit. An “account” in this context corresponds to a row in the mysql.user system table. That is, a connection is assessed against the User and Host values in the user ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Table 8.26 Plugin and Library Names for WebAuthn Authentication Plugin or File Plugin or File Name Server-side plugin authentication_webauthn Client-side plugin authentication_webauthn_client Library file authentication_webauthn.so, ... Note ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/index.html
Abstract This is the user manual for MySQL Enterprise Backup, a commercially licensed backup utility for MySQL databases. It explains the different kinds of backup and restore that can be performed with MySQL Enterprise Backup, and describes the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
For details on how the MySQL server encrypts and decrypts InnoDB tablespaces, see InnoDB Data-at-Rest Encryption—it explains concepts like master key and tablespace keys, which are important for understanding how MySQL Enterprise Backup works with ...Notes Since the keyring_file and the keyring_encrypted_file plugins have been removed from the MySQL Server since release 8.4.0, they are no longer supported by MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-faq.html
This file represents the InnoDB system tablespace, which grows but never shrinks as a database server operates, and is included in every full and incremental backup. The ibdata1 file in the incremental backups is typically much smaller, containing ... This section lists some common questions about MySQL Enterprise Backup, with answers and pointers to further ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-myisam.html
mysqlbackup also backs up the .MYD files, .MYI files, and the .sdi files associated with the MyISAM tables. Files with other extensions that are backed up are shown in Table 1.1, “Types of Files in a Backup”. Note While MySQL Enterprise Backup ...