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/memory-storage-engine.html
(This is an uncommon feature for implementations of hash indexes.) Columns that are indexed can contain NULL values. To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: 100.00 Extra: Using index condition; Using filesort See also Section 8.9.2, “Switchable ... If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
Either function produces an error if its (non-null) argument cannot be parsed as a valid JSON document, and NULL if the argument is NULL. Each member of the second object for which there is no member having the same key in the first object, and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
Note In MySQL 5.7, it is possible to match against only a list of integers (and possibly NULL—see Section 22.2.7, “How MySQL Partitioning Handles NULL”) when partitioning by LIST. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The value is non-NULL only for accounts that use MySQL built-in authentication methods (accounts that use an authentication plugin of mysql_native_password or sha256_password). The value is NULL for other accounts, such as those authenticated using ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
--output-type=name Command-Line Format --output-type=name Introduced 5.7.18-ndb-7.6.2 Type Enumeration Default Value ndb Valid Values null Set the output type. ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
A successful call to audit_log_read() to read events returns a JSON string containing an array of audit events: If the final value of the returned array is not a JSON null value, there are more events following those just read and audit_log_read() ... The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
Before downgrading from MySQL 5.7, review the information in this section. System Table Changes InnoDB Changes Logging Changes SQL Changes System Table Changes In MySQL 5.7.13, system table columns that store user@host string values were increased ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
This section describes how to set up the daemon_memcached plugin on a MySQL server. Because the memcached daemon is tightly integrated with the MySQL server to avoid network traffic and minimize latency, you perform this process on each MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...