Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
The plugin interprets the audit_log_file value as composed of an optional leading directory name, a base name, and an optional suffix. This section describes how to configure audit logging characteristics, such as the file to which the audit log ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer perform inserts. You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
You can use the --log-bin option to specify an alternative location, by adding a leading absolute path name to the base name to specify a different directory. The binary log contains “events” that describe database changes such as table ...
https://dev.mysql.com/doc/refman/8.4/en/charset-syntax.html
The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads to natural and obvious results. There are default settings for character sets and collations at four levels: ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
Also, keep in mind the general principle that if a table has different definitions on the source and replica, this can lead to unexpected results. This section describes issues that you may face when converting character data between the utf8mb3 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
For _bin collations except utf8mb4_0900_bin, the weight is based on the code point, possibly with leading zero bytes added. This section describes the collations available for Unicode character sets and their differentiating properties. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
Within option names, dash (-) and underscore (_) may be used interchangeably in most cases, although the leading dashes cannot be given as underscores. Program options specified on the command line follow these rules: Options are given after the ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
To accommodate a large number of simultaneous connections, the stack size per thread must be kept small, leading to a situation where it is either too small or the server consumes large amounts of memory. This section describes aspects of how the ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...