Search Results
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
In this case, the file should have a restrictive mode and be accessible only to the account used to run the migration server. MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
An UPDATE statement involving a temporary table with a join on a non-temporary table having a trigger defined on it can result in an error, even though the update statement reads only the non-temporary table, in the following cases: With read-only ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-rules.html
Suppose that '0' and '1' have weights of 0E29 and 0E2A and we want to put all basic Latin letters between '0' and '1': <reset>0</reset> <pc>abcdefghijklmnopqrstuvwxyz</pc> For simple shift mode, weights are calculated as follows: 'a' has weight ...
https://dev.mysql.com/doc/refman/8.4/en/logical-operators.html
Table 14.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
For use in single user mode, an entry for _mysql (note the underscore prefix) should already exist within the system /etc/passwd file. You should keep the following issues and notes in mind: Other MySQL installations: The installation procedure ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
In autocommit mode, each statement is in effect a complete transaction, so metadata locks acquired for the statement are held only to the end of the statement. MySQL uses metadata locking to manage concurrent access to database objects and to ...
https://dev.mysql.com/doc/refman/8.4/en/my-print-defaults.html
my_print_defaults displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified option groups. For example, the mysqlcheck program reads the [mysqlcheck] and ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-ftdump.html
It reads the MyISAM index file directly, so it must be run on the server host where the table is located. Before using myisam_ftdump, be sure to issue a FLUSH TABLES statement first if the server is running. myisam_ftdump scans and dumps the entire ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors occur. It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-optimization.html
To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL statement.