Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meters.html
For example, to update the frequency of the mysql.inno metrics: mysql>update performance_schema.setup_meters set FREQUENCY='30' where name = 'mysql.inno'; The maximum number of meter instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
If you are uninstalling a plugin with no intention of reinstalling it later and you care about the table contents, you should dump the table with mysqldump and remove the WITH PARSER clause from the dumped CREATE TABLE statement so that you can ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, collation_connection, Database Collation attributes displayed by SHOW TRIGGERS or the INFORMATION_SCHEMA TRIGGERS table). To ...
https://dev.mysql.com/doc/refman/8.4/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/8.4/en/while.html
Example: CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5; WHILE v1 > 0 DO ... [begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-2.html
Bugs Fixed InnoDB: In some cases, following the creation of a very large number of tables (8001 or more), the server could not be restarted successfully. (Bug #110402, Bug #35200385) Group Replication: Running a CREATE TABLE ... (Bug #36808732) ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backing-up.html
This section explains the preparations you need for creating backups with MySQL Enterprise Backup, the typical backup-verify-restore cycle, and the different backup scenarios for using MySQL Enterprise Backup. It also includes sample commands and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-apply-log.html
A directory backup, just like a single-file backup, can be prepared and restored using the copy-back-and-apply-log command as explained at the beginning of Section 5.1, “Performing a Restore Operation”. Example 5.10 Restoring a Backup Directory ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-validate.html
To ensure the integrity of the backup data, MySQL Enterprise Backup provides a validate command for validating a backup by the checksum values of its data pages after the backup is created or transferred to another system. mysqlbackup [STD-OPTIONS] ...