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/socket-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”). The server-side auth_socket authentication plugin authenticates clients ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
To determine which storage engines your server supports, use the SHOW ENGINES statement. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
This includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. However, the time shown in the Information Schema EVENTS table's LAST_EXECUTED column or the mysql.event table's ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
In EXPLAIN output, the fallback shows up as Full scan on NULL key in the Extra column: mysql> EXPLAIN SELECT t1.col1, t1.col1 IN (SELECT t2.key1 FROM t2 WHERE t2.col2=t1.col2) FROM t1\G *************************** 1. row *************************** ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
You can check the maximum data and index sizes by using this statement: SHOW TABLE STATUS FROM db_name LIKE 'tbl_name'; You also can use myisamchk -dv /path/to/table-index-file. See Section 13.7.5, “SHOW Statements”, or Section 4.6.3, ... The ...
https://dev.mysql.com/doc/refman/5.7/en/test-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”). MySQL includes a test plugin that checks account credentials and logs ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. The complete trace is shown here: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
To assist in the migration, you can use the show_compatibility_56 system variable, which affects how system and status variable information is provided by the INFORMATION_SCHEMA and Performance Schema tables, and also by the SHOW VARIABLES and SHOW ... Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
This section describes the options, system variables, and status variables that validate_password provides to enable its operation to be configured and monitored. The value should be one of those available for plugin-loading options, as described ...
https://dev.mysql.com/doc/refman/5.7/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.