Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-innodb.html
If you use the compressed backup feature, the .ibd files are renamed in their compressed form to .ibz files. The backed-up files, as they are originally copied, form a raw backup that requires further processing. The apply step (either as part of a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-upgrade.html
Users interested in the topic are advised to consult the MySQL server manual, especially the Upgrading MySQL and Downgrading MySQL sections, and pay careful attention to the requirements and restrictions discussed there. Install on the target server ... Important You may encounter technical challenges during a server upgrade or downgrade, and it is beyond the function of MySQL Enterprise Backup, as a backup tool, to ensure a successful server upgrade or ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). Since ndb_log_apply_status can be changed at runtime and subscriptions are not recreated at ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-installation-linux.html
Installing MySQL Router using an official DEB or RPM package creates a local system user and group named "mysqlrouter" on the host that MySQL Router runs as by default. There are binary distributions of MySQL Router available for several variants ...
https://dev.mysql.com/doc/internals/en/cs-sect-expired-password.html
Since MySQL 5.6.7, a MySQL account can be expired with ALTER USER account PASSWORD EXPIRE. If a client is not setting that capability and it tries to login with an account that has an expired password, the server will return an ERR packet for the ...If a account is expired, the session is in a restricted mode which only permits SET PASSWORD ...All other statements fail with an error like this: mysql> SELECT 1; ERROR 1820 (HY000): You must SET PASSWORD before executing this statement On the protocol side exists ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-cost.html
However, enabling CloudWatch monitoring will incur charges on your AWS account. Users should consult the Amazon CloudWatch Pricing for details on CloudWatch-related charges. Here is a breakdown of the charges to your AWS account incurred by enabling ... Cost for Using CloudWatch Monitoring 17.1.2 Cost for Using CloudWatch Monitoring There are no surcharges for using CloudWatch monitoring in MySQL HeatWave on ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
Change to the standard mouse pointer tool and pick up any objects you would like to place on the newly created layer. For more information about text objects, see Section 9.1.9, “Creating Text Objects”. 9.1.2.2.7 The Table Tool Use this tool to ... The vertical toolbar appears on the left sidebar (see the following figure) when an EER diagram tab is ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.4. When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...