PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html
If you have upgraded to a release earlier than MySQL 8.0.16, invoke mysql_upgrade manually to upgrade the system tables and schemas. When you upgrade servers that participate in a replication topology, you need to take into account each server's ...
https://dev.mysql.com/doc/refman/5.7/en/reserved-accounts.html
One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data Directory”). During data directory initialization, MySQL creates user accounts that should be considered reserved: ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: 46b876e64cd5c41009d91c754921f1d4 normalized_pattern: select ? For information about statement ... To ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
row *************************** Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO XA: NO Savepoints: NO *************************** 9. Storage engine information is also available from the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
This is the same value displayed in the ID column of the INFORMATION_SCHEMA PROCESSLIST table, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. SHOW ...
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”). For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ... The ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
As a result, identifiers that are the same as function names must be quoted as described in Section 9.2, “Schema Object Names”. The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
Important The password that you set using START SLAVE is masked when it is written to MySQL Server’s logs, Performance Schema tables, and SHOW PROCESSLIST statements. START SLAVE [thread_types] [until_option] [connection_options] [channel_option] ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
However, the time shown in the Information Schema EVENTS table's LAST_EXECUTED column or the mysql.event table's last_executed column is always accurate to within one second of the actual event execution time. Some of the restrictions noted here ...
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-table-from-file-name.html
This function is useful when extracting file I/O information from the Performance Schema that includes file path names. Given a file path name, returns the path component that represents the table name. It provides a convenient way to display table ...