Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
For example, Create DB and Change user correspond to COM_CREATE_DB and COM_CHANGE_USER, respectively. The value is composed from a sequence number and timestamp, in the format SEQ_TIMESTAMP. When the audit log plugin opens the audit log file, it ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
If compression or encryption are enabled, the effective file name (the name actually used to create the log file) differs from the configured file name because it has additional suffixes: If compression is enabled, the plugin adds a suffix of .gz.
https://dev.mysql.com/doc/refman/8.4/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...If you specify only the connection name without a table name, the table name of the local table is used ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
(NDB 8.4.0) This parameter specifies the directory where all files created for metadata, REDO logs, UNDO logs (for Disk Data tables), and data files are placed. The recommended directory hierarchy for NDB Cluster includes /var/lib/mysql-cluster, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
External tables use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object Storage. CREATE EXTERNAL TABLE table_name (col_name data_type ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. It is strongly recommended that you never change the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/backup-strategy-example.html
You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. Assume also that the ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
As of MySQL 9.3.0, you can create temporary tables that are stored in the MySQL HeatWave Cluster. Once created, you can use a MySQL HeatWave temporary table as an independent entity. After the MySQL HeatWave temporary table is created, you can ...A ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Creating a Channel 8.5 Creating a Channel Note:In MySQL replication, a replica is a MySQL server that receives changes from another MySQL server (source) and applies the changes. The value is also available as metadata in the gtidExecuted field in ...In MySQL HeatWave on AWS, a Channel references the replica as the target DB ...