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/create-table-secondary-indexes.html
This technique also can be used to provide indexes that indirectly reference columns of other types that cannot be indexed directly, such as GEOMETRY columns. This means that any NDB table having one or more JSON columns must have a primary key, ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM (SELECT SUM(column1) AS sum_column1 FROM t1 GROUP BY column1) AS t1; Notice that the column ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. If your intention is to use MySQL in a traditional (SQL) way, this chapter is probably not relevant to you. This ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
Use the private key to encrypt data and the public key to decrypt it This requires that the members of the key pair be RSA keys. For some installations, this might result in unacceptable CPU usage if applications frequently generate excessively long ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
Usually, most of the data obtained in this way is intact. If an unexpected exit would occur during the purge operation, this recovery value prevents it. After using this value, be prepared to drop and recreate all secondary indexes. In this case, ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-group-membership.html
In this situation, Group Replication's failure detection mechanism recognizes after a short period of time that the member has left, and a reconfiguration of the group without the failed member is proposed. In this situation, the rejoining member ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-view-changes.html
This section explains the process which controls how the view change identifier is incorporated into a binary log event and written to the log, The following steps are taken: Begin: Stable Group All servers are online and processing incoming ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
This information is used when populating the server_operations and server_transactions tables of the ndbinfo NDB Cluster information database. Although the names of this table and its columns are displayed using lowercase, you can use uppercase or ... The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
This number is incremented when a statement starts executing, not when it finishes. This does not count statements that the thread group was able to begin executing immediately without queuing, which can happen under the conditions described in ...