PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
mysql> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' \\ FOR CHANNEL 'group_replication_recovery'; Distributed recovery is the first step taken by a server that joins the group and does not have the same set of transactions as ...Therefore you need to set up a replication user with the correct permissions so that Group Replication can establish direct member-to-member recovery replication ... Group ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
The exception is for “mixed-mode inserts”, where the user provides explicit values for an AUTO_INCREMENT column for some, but not all, rows in a multiple-row “simple insert”. Specifying NULL or 0 for the AUTO_INCREMENT column In all lock ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-latency.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total_latency The total wait time of timed statements for the user. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
In such cases, the server returns ER_HOST_NOT_PRIVILEGED and does not even ask for a user name or password. For example, the database does not exist or the user has no privileges to access it. MySQL does not perform matching of Host column values in ...COUNT_HOST_ACL_ERRORS The number of errors that occur because no users are permitted to connect from the client ... The MySQL server maintains an in-memory host ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
A “login path” is an option group that permits only certain options: host, user, password, port and socket. If multiple instances of a given option are found, the last instance takes precedence, with one exception: For mysqld, the first instance ...[group] group is the name of the program or group for which you want to set ...(For mysqld, use --verbose and --help.) If the program reads option files, the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
As with any other MySQL Server, user and privilege information is stored in the mysql system database. A user who can log in as root can also access the INFORMATION_SCHEMA database and its tables, and so obtain information about databases, tables, ...If you wish, you can enable automatic distribution of MySQL users and privileges across NDB Cluster SQL nodes; see Section 21.6.13, “Distributed Privileges Using Shared Grant Tables”, for ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
The user-selected rule by which the division of data is accomplished is known as a partitioning function, which in MySQL can be the modulus, simple matching against a set of ranges or value lists, an internal hashing function, or a linear hashing ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
For additional information about the REQUIRE clause, see Section 13.7.1.2, “CREATE USER Statement”. For example: mysql --ssl-mode=REQUIRED mysqldump --ssl-mode=VERIFY_CA mysqladmin --ssl-mode=VERIFY_IDENTITY To configure a MySQL account to be ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
If conditions that cover sets of rows contained within intervals are combined with OR, they form a condition that covers a set of rows contained within the union of their intervals. If the conditions are combined with AND, they form a condition that ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
For other summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For other summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, ...Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST ...