PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
The following table shows the permitted level values and their meanings. The following table shows the permitted level values and their meanings. Communication between the authentication plugin and the LDAP server occurs according to this ...
https://dev.mysql.com/doc/refman/5.7/en/primary-key-optimization.html
The primary key for a table represents the column or set of columns that you use in your most vital queries. With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column ...Query performance benefits from the NOT NULL optimization, because it cannot include any NULL ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular expression RLIKE Whether string matches regular expression A regular expression is a powerful way of ...This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
Details of the error and the last successfully applied transaction are recorded in the Performance Schema table replication_applier_status_by_worker. If the failing transaction generated an error in a worker thread, you can obtain its GTID directly ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-status.html
From MySQL 5.7, the Performance Schema has replication tables that provide this information in a more accessible form. The replication_connection_status Performance Schema table shows when the most recent heartbeat signal was received by a replica, ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-create-if-not-exists.html
Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, whether or not the table already exists on the source. SELECT follows somewhat different rules; see Section 16.4.1.6, “Replication of CREATE TABLE ... IF NOT ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-views.html
Views are filtered by their own name, not by the tables they refer to. This means that a view can be replicated to the replica even if the view contains a table that would normally be filtered out by replication-ignore-table rules. Care should ...
https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; 16.1.2.5.1 Setting the Replica Configuration Each replica must have a unique server ID, as specified by the server_id system variable. The connection metadata repository can be in the form ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
To revoke all privileges, use the second syntax, which drops all global, database, table, column, and routine privileges for the named user or users: REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... REVOKE removes privileges, but does not ...The REVOKE statement enables system administrators to revoke privileges from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
The Rewriter plugin uses a database named query_rewrite containing a table named rewrite_rules. The table provides persistent storage for the rules that the plugin uses to decide whether to rewrite statements. Users communicate with the plugin by ...