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/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
If an error occurs, the column value is the GTID of the transaction being executed by the worker when the error occurred. LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent worker error occurred. If gtid_mode ... If the replica is not multithreaded, this table shows the status of the applier ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
As of MySQL 5.7.18, for any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error if not. These privileges enable the admin user to execute the mysqladmin reload, mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. The implementation comprises these elements: Keyring plugins that manage a backing store or communicate ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
The administrator needs to execute a statement like this: mysql> GRANT ALL ON menagerie.* TO 'your_mysql_name'@'your_client_host'; where your_mysql_name is the MySQL user name assigned to you and your_client_host is the host from which you connect ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view displays indexes that duplicate other indexes or are made redundant by them. In the following column descriptions, the dominant index is the one that makes the redundant index redundant. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. Use NULL to ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, any rows preceding the error have already been inserted. The exception is that, for TIMESTAMP and DATETIME columns, you ... Data type specifications can have explicit or implicit default ...
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 ...