Search Results
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). Note If the replication ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The parent query does not set a user variable, since rewriting it may affect the order of execution, which could lead to unexpected results if the variable is accessed more than once in the same query. Its value is a set of flags, each of which has ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.full.html
After you have created a full backup, you might perform incremental backups (which are smaller and faster) for the next several backup tasks. This section outlines some of the things to consider when deciding on a strategy for creating full backups.
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Error number: 2072; Symbol: CR_INVALID_FACTOR_NO; Message: Invalid first argument for MYSQL_OPT_USER_PASSWORD option. Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
The first time the server calls event_notify for a thread, it creates a binding of the plugin to the thread. */ MYSQL_AUDIT_CONNECTION_DISCONNECT = 1 << 1, /** occurs after COM_CHANGE_USER RPC is completed. */ MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
See Creating an IAM Role to Access an Amazon S3 Bucket, Creating a DB System, and Editing a DB System. Create a new database or use an existing database to bulk ingest data. For example, the following query creates a new database, airportdb, and ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
(Although you can write an ON DELETE or ON UPDATE clause as part of the REFERENCES clause, it is also ignored.) This syntax creates a column; it does not create any sort of index or key. row *************************** Table: shirt Create Table: ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
ARRAY is not supported except when used to create a multi-valued index in one of these statements, in which case it is required. Note CONVERT(), unlike CAST(), does not support multi-valued index creation or the ARRAY keyword. Other Uses for Cast ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. Only undo tablespaces created using CREATE UNDO TABLESPACE syntax can be dropped. Similar to the system tablespace, ...The ...