Search Results
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 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-added.html
An alternative to generating and running the ALTER ONLINE TABLE ... REORGANIZE PARTITION steps is to make use of the logical backup of the NDB tables' metadata, which is part of the cluster backup created by MySQL Cluster Manager. Restore the ... A ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-requirements.html
In such cases data is not automatically distributed to the new nodes, and, following the restore, you must redistribute the data manually by issuing an ALTER ONLINE TABLE ... REORGANIZE PARTITION statement in the mysql client for each NDB table in ... This section provides information about basic requirements for performing backup and restore operations using MySQL Cluster ...
https://dev.mysql.com/doc/c-api/8.4/en/getting-unique-id.html
If you insert a record into a table that contains an AUTO_INCREMENT column, you can obtain the value stored into that column by calling the mysql_insert_id() function. You can check from your C applications whether a value was stored in an ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-refresh.html
This function flushes tables or caches, or resets replication server information. int mysql_refresh(MYSQL *mysql, unsigned int options) Description Note mysql_refresh() is deprecated and is subject to removal in a future version of MySQL. The ...