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/connecting-using-uri-or-key-value-pairs.html
For information on establishing connections using command-line options, for clients such as mysql or mysqldump, see Section 6.2.4, “Connecting to the MySQL Server Using Command Options”. Use mysqlx for X Protocol connections and mysql for ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. These options can be given on ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ...] For each text file named on the command line, mysqlimport strips any ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
For window function usage information and examples, and definitions of terms such as the OVER clause, window, partition, frame, and peer, see Section 14.20.2, “Window Function Concepts and Syntax”. PERCENT_RANK() Percentage rank value RANK() ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
For example, in the above scenario of 5 servers where 3 leave at once, if the 3 leaving servers warn the group that they are leaving, one by one, then the membership is able to adjust itself from 5 to 2, and at the same time, securing quorum while ...This is the case for regular transactions but is also required for group membership changes and some internal messaging that keeps the group ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
Because enabling compression decreases performance, its benefits occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. To configure that ... Connections to the server can use compression on the traffic between client and server to reduce the number of bytes sent over the ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
START REPLICA with no thread type options starts all of the replication threads, and so does START REPLICA with both of the thread type options. IO_THREAD starts the replication receiver thread, which reads events from the source server and stores ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. Support for DELETE, INSERT, ...Statements and Functions Full operator and function support in the SELECT list and WHERE clause of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
Ndb_conflict_fn_max: Number of times that NDB replication conflict resolution based on "greater timestamp wins" has been applied to update and delete operations. Ndb_conflict_fn_max_del_win: Number of times that NDB replication conflict resolution ...ndb-log-empty-epochs: When enabled, causes epochs in which there were no changes to be written to ndb_apply_status and ndb_binlog_index tables, even when --log-slave-updates is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-migrate-keyring.html
The mysql_migrate_keyring utility migrates keys between one keyring component and another. Invoke mysql_migrate_keyring like this (enter the command on a single line): mysql_migrate_keyring --component-dir=dir_name --source-keyring=name ...For ...