Search Results
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-aiaml-error-messages.html
Error number: ML003016; SQLSTATE: HY000 Message: Missing argument \"row_json\" in input JSON -> dict_keys(['%', '%']). Example: ERROR HY000: ML003016: Missing argument \"row_json\" in input JSON -> dict_keys(['operation', 'user_name', 'table_name', ... Each error message includes an error number, SQLSTATE value, and message string, as described in Error Message Sources and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
When MySQL Enterprise Monitor normalizes queries, it disregards differences in keyword capitalization, whitespace, and most comments. QuAn An abbreviation for Query Analyzer used in some keyword names. These terms are commonly used in information ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-prerequisites.html
As the DB system high availability feature uses MySQL Group Replication, for which each table must have a primary key. If you try to create a table without a primary key in a high availability DB system, it will fail. If you are migrating tables to ... Prerequisites 12.2 Prerequisites Here are some prerequisites for creating a high availability DB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
For example, the left-arrow and right-arrow keys move horizontally within the current input line, and the up-arrow and down-arrow keys move up and down through the set of previously entered lines. On Windows, the editing key sequences are the same ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. The server recognizes but ignores the DELAYED ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
WebAuthn pluggable authentication provides these capabilities: WebAuthn enables authentication to MySQL Server using devices such as smart cards, security keys, and biometric readers. When device registration has been performed for the account, the ... Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-cloud.html
mysqlbackup --defaults-file=/home/dbadmin/my.cnf --backup-dir=/home/dbadmin/backuptmp --with-timestamp \ --backup-image=- --cloud-service=OCI --cloud-par-url=<bucket_PAR_URL> --cloud-object=backup-inc.bk \ --incremental ...Only single-file backups ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-security.html
paranoid Take measures to prevent exposure sensitive information in error messages and clear data structures holding sensitive data when possible? Default Value false Since Version 3.0.1 serverRSAPublicKeyFile File path to the server RSA public key ...Default Value false Since Version 5.1.31 sslMode By default, network connections are SSL encrypted; this property permits secure connections to be turned off, or a different levels of security to be ...
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.