PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. Using the information obtained from the query ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). For alternative methods of protecting proxied accounts against direct use, ... The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses ...
https://dev.mysql.com/doc/refman/5.7/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Remove ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The following example provides one methodology that you can use to analyze a repeatable problem, such as investigating a performance bottleneck. To begin, you should have a repeatable use case where performance is deemed “too slow” and needs ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| stage/sql/end | NO | NO ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-startup-configuration.html
Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within the name are equivalent. The other variables indicate table sizes (number of rows) or memory allocation values. For example, ... To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to ...
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. Alternatively, you can issue SHOW RELAYLOG EVENTS on the replica or SHOW BINLOG EVENTS on the ...