Search Results
https://dev.mysql.com/doc/refman/9.7/en/openid-pluggable-authentication.html
Authentication is successful if all the required criteria are met, otherwise authentication fails and logs the appropriate information to the error log. Note OpenID Connect pluggable authentication is an extension included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/9.7/en/option-files.html
Programs that do not understand the option quit after displaying an error message if you try to run them. Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way ...
https://dev.mysql.com/doc/refman/9.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1 type: range possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: NULL rows: 7 Extra: Using where If EXPLAIN is used to examine a query against a nonpartitioned ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 9.7. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-functions.html
If the Performance Schema itself is disabled, PS_THREAD_ID() produces an error. MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. connection_control_failed_login_attempts: The current ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-ndb-replication-applier-status-table.html
CONFLICT_REFLECTED_OP_DISCARD_COUNT: The nmber of reflected operations which have not been applied due to errors during execution. NDBCLUSTER exposes its internal replication applier state for observation using global status variables such as ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-prepared-statements-instances-table.html
The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol. This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. C ...