Search Results
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. row *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html
row *************************** Privilege: Alter Context: Tables Comment: To alter the table *************************** 2. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. The value should match the THREAD_ID column from some ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). Tables in these schemas are excluded ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view has these columns: table_schema The schema that contains the table. The x$schema_flattened_keys view has these columns: table_schema The schema that contains the table. The schema_redundant_indexes view displays ...
https://dev.mysql.com/doc/refman/8.4/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. If you do this often, it is very ... An ...
https://dev.mysql.com/doc/refman/8.4/en/workbench.html
Data Modeling: Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. The Table Editor provides ... MySQL Workbench provides a graphical tool for working with MySQL servers and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-encrypted-innodb-options.html
MySQL Enterprise Backup supports encrypted InnoDB tablespaces and encrypted binary/relay logs. See Chapter 6, Working with Encrypted InnoDB Tablespaces and Section 8.4, “Working with Encrypted Binary and Relay Logs” on how mysqlbackup commands ...For details on how MySQL Server encrypts and decrypts these items, see InnoDB Data-at-Rest Encryption and Encrypting Binary Log Files and Relay Log ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-innodb.html
Note To avoid concurrency issues during backups of busy databases, you can use the --only-innodb option to back up only InnoDB tables and the associated data. If you use the compressed backup feature, the .ibd files are renamed in their compressed ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-issues-mysql-cluster.html
You can back up NDB databases and tables using the mcm client backup cluster command, and restore them using the restore cluster client command. You can also back up NDB databases and tables using the ndb_mgm client START BACKUP command, and restore ... This section describes limitations relating to MySQL NDB Cluster functionality that is unsupported or curtailed by MySQL Cluster Manager ...