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/password-management.html
Clients that connect to the server using the account then get an error indicating that the password must be changed: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. Operations performed by ...Password expiration according to policy is automatic and is based on password age, which for a given account is assessed from the date and time of its most recent password ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html
To see the values used by a given instance, connect to it and execute a SHOW VARIABLES statement. If you use the following log file options, their values must differ for each server: --general_log_file=file_name --log-bin[=file_name] ... In some ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Configuration Options ps_thread_trx_info() operation ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
Although an ALTER EVENT statement that contains another ALTER EVENT statement in its DO clause appears to succeed, when the server attempts to execute the resulting scheduled event, the execution fails with an error. When a user executes a ... ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL now enables database administrators to establish a policy for automatic password expiration: Any user who connects to the server using an account for which the password is past its permitted lifetime must change the password. (The server ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
FILE_SIZE The apparent size of the file, which represents the maximum size of the file, uncompressed. The INNODB_SYS_TABLESPACES table provides metadata about InnoDB file-per-table and general tablespaces, equivalent to the information in the ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
At one time, a scan was used based on whether the best index spanned more than 30% of the table, but a fixed percentage no longer determines the choice between using an index or a scan. This section discusses optimizations that can be made for ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary.html
statement_latency The total wait time of timed statements for the host. statement_avg_latency The average wait time per timed statement for the host. file_io_latency The total wait time of timed file I/O events for the host. These views summarize ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary.html
statement_latency The total wait time of timed statements for the user. statement_avg_latency The average wait time per timed statement for the user. file_io_latency The total wait time of timed file I/O events for the user. These views summarize ...