Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
CREATE TABLE t2 (a INT) ENGINE = MyISAM; -- Transaction 1 COMMIT -- (implicit; DDL forces commit) 6. COMMIT; -- Transaction 2 COMMIT From the perspective of the server, Transaction 1 ends when table t2 is created. The cost of transaction ...Within ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-assign-anon.html
For a channel on a Group Replication group member, do not specify the Group Replication group name as the UUID for creating the GTIDs. The exception to this is any downstream replicas of the replica where you enabled ... You can set up replication ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html
On Windows, MySQL Installer interacts with the user and creates a file named my.ini in the base installation directory as the default option file. For non-Windows platforms, no default option file is created during either the server installation or ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
These two statements are equivalent: SHOW COLUMNS FROM mytable FROM mydb; SHOW COLUMNS FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden columns that MySQL uses internally and are not accessible ... SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-single-file.html
Besides the commands for creating and restoring single-file backups (namely, backup-to-image and copy-back-and-apply-log), mysqlbackup provides a number of other commands for you to work with single-file backups. Note image-to-backup-dir only ...To ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encryption.html
The encryption can also be applied when creating a partial, compressed, or incremental single-file backups, and for streaming backup data to another device or server. The encryption is performed with Advanced Encryption Standard (AES) block cipher ... In order to enhance security for backed up data, MySQL Enterprise Backup provides encryption for single-file ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-windows-service.html
The installation is performed using the command prompt (cmd.exe); as with installing or removing any Windows service, it must also be done as a user having sufficient permissions, such the system Administrator account. To install the MySQL Cluster ... Important Installation of the MySQL Cluster Manager agent as a service is ...
https://dev.mysql.com/doc/relnotes/mysql-router/8.4/en/news-8-4-6.html
(Bug #38009073) Users created with a comment in their definition were unable to connect using MySQL Router. Note These release notes were created with the assistance of MySQL HeatWave GenAI. This change affects the auto-generated certificates ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/adding-replicaset-instances.html
When you have created a ReplicaSet, you can use the ReplicaSet.addInstance() operation to add an instance as a read-only secondary replica of the current primary of the ReplicaSet. MySQL Replication is configured between the added instance and the ...The primary of the ReplicaSet must be reachable and available during this ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-overview.html
In addition, AdminAPI supports administration of some MySQL Router related tasks, such as creating or upgrading a user account that works with InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. For example, use the dba.createCluster() method ...AdminAPI is accessed through the dba global variable and its associated ...