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/get-diagnostics.html
(You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The keyword STACKED means to retrieve information from the second diagnostics area, which is available only ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
In this case, the server does not acquire the query cache mutex at all, which means that the query cache cannot be enabled at runtime and there is reduced overhead in query execution. Note You can set the maximum size that can be specified for the ...For example, a client can disable use of the query cache for its own queries like this: mysql> SET SESSION query_cache_type = OFF; If you set query_cache_type at server startup (rather than at runtime with a SET statement), only the numeric values are ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
A query that fails to parse differs from a query that parses but fails due to an error during execution. Consequently, there is no parsing at runtime and the type of each statement is known by the time it executes. The setup_timers table contains a ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
To dig deeper into performance considerations for compressed tables, you can monitor compression performance at runtime using the Information Schema tables described in Example 14.1, “Using the Compression Information Schema Tables”. This ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
For an event, an error occurs at event execution time if the account does not exist. Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. rpl_stop_slave_timeout: Number of seconds that STOP REPLICA or STOP SLAVE waits before timing out. slave_net_timeout: Number of seconds to ...enforce_gtid_consistency: Prevents execution of statements that cannot be logged in transactionally safe ... The following two sections provide basic ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 6.2, “Access Control and Account Management”, and Section 6.2.17, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
Time The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. SHOW [FULL] PROCESSLIST ...For a comparison of this statement with other sources, see Sources of Process ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
An unqualified name is permitted in contexts where interpretation of the name is unambiguous. A qualified name includes at least one qualifier to clarify the interpretive context by overriding a default context or providing missing context. For ...