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/workbench/en/wb-sql-editor.html
Together the editors and panels enable you to: Build, edit, and run queries Create and edit data View and export results Perform basic RDBMS administrative tasks Color syntax highlighting, context help, and code completion assist you in writing and ... The visual SQL editor consists of a set of specialized editors (query, schema, table, and so on) and three panels: sidebar, secondary sidebar, and output ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
Common uses are the cleanup of obsolete data, the creation of summary tables for statistics, and monitoring of server performance and usage. In-Memory Temporary Table Size Limited By Maximum Heap Table Size Description If the space required to build ...The binary log enables point-in-time recovery, preventing data loss during a disaster recovery ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-add.html
The collection needs to be created with the Schema.createCollection() function before documents can be inserted. The Collection.add() function is for storing documents in a collection, similar to the INSERT statement for an SQL database. It takes a ...