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/sha256-pluggable-authentication.html
A client user who can connect to the server some other way can use a SHOW STATUS LIKE 'Rsa_public_key' statement and save the returned key value in a file. MySQL provides two authentication plugins that implement SHA-256 hashing for user account ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
This prevents most The table tbl_name is full errors for SELECT operations that require a large temporary table, but also slows down queries for which in-memory tables would suffice. When using internal_tmp_disk_storage_engine=INNODB (the default), ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. As a result, the address value for rows within each name group is ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
The query cache probes are best combined with a probe on the main query so that you can determine the differences in times between using or not using the query cache for specified queries. A high number of keycache reads across a range of queries ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
If you use statement-based or mixed binary logging format, do not use cross-database queries, and do not specify database names in queries. For both DDL and DML statements, rely on the USE statement to specify the current database, and use only the ... This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
The desired result is that both queries return the same result (the input time, converted to the equivalent value in the 'US/Central' time zone). This section describes the time zone settings maintained by MySQL, how to load the system tables ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
In such cases, all index-using queries of the form shown match at most one index entry. It remains true that index-using queries match the converted search value to a single value in the UTC index entries, rather than matching multiple UTC values ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
<cache>(expr) The expression (such as a scalar subquery) is executed once and the resulting value is saved in memory for later use. See Section 8.2.2.1, “Optimizing Subqueries, Derived Tables, and View References with Semijoin Transformations”.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
You can use the following query to obtain the needed records from the ndb_binlog_index table on the source: mysqlS'> SELECT -> @file:=SUBSTRING_INDEX(next_file, '/', -1), -> @pos:=next_position -> FROM mysql.ndb_binlog_index -> WHERE epoch = ... In ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
For Windows, the tee option can be used instead to save query output, although it is not as convenient as pager for browsing output in some situations. If you are running with --safe-updates enabled, status also prints the values for the mysql ...