PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
Options on the command line take precedence over values specified in option files and environment variables, and values in option files take precedence over values in environment variables. In many cases, it is preferable to use an option file ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id system variable to establish a unique replication ID. For each server, you should pick a unique positive integer ... This section describes the server options and system variables that you can use on replication source ...--show-replica-auth-info Command-Line Format --show-replica-auth-info[={OFF|ON}] Introduced 8.0.26 Type Boolean Default ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. If you are adding data to a nonempty table, you can tune the bulk_insert_buffer_size variable to ...The size of the table slows down the insertion of indexes by log N, assuming B-tree ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
If validate_password rejects the new password, it reports an error indicating the minimum number of characters that must differ. If the file is named as a relative path, it is interpreted relative to the server data directory. For the dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
If your system has its own zoneinfo database (the set of files describing time zones), use the mysql_tzinfo_to_sql program to load the time zone tables. Nor are values in those data types stored in UTC; the time zone applies for them only when ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
They do not help marking a specific point in time to which the server joining the group must catch up, nor do they convey certification information. This is the job of binary log view markers, which mark view changes in the binary log stream, and ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html
In short, the safest methods are to have the client program prompt for the password or to specify the password in a properly protected option file. Use the mysql_config_editor utility, which enables you to store authentication credentials in an ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be specified. On 32-bit platforms, the supported range of values for this function is ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
You cannot merge MyISAM tables in which the columns are listed in a different order, do not have exactly the same data types in corresponding columns, or have the indexes in different order. When you create a MERGE table, MySQL creates a .MRG file ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...