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/functions.html
Rather than showing examples in this format: mysql> SELECT MOD(29,9); +-----------+ | mod(29,9) | +-----------+ | 2 | +-----------+ 1 rows in set (0.00 sec) This format is used instead: mysql> SELECT MOD(29,9); -> 2 . Expressions can be used at ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server keeps tablespace metadata in memory for the lifetime of a tablespace. Multiple tables in fewer general tablespaces consume less memory for ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
If Loose Index Scan is applicable to a query, the EXPLAIN output shows Using index for group-by in the Extra column. The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
The options which configure Group Replication are shown in the following table. The following example shows an example my.cnf file section used to configure SSL on a server and how activate it for Group Replication. Group communication connections ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-server-states.html
No UNREACHABLE Whenever the local failure detector suspects that a given server is not reachable, because for example it was disconnected involuntarily, it shows that server's state as UNREACHABLE. There are various states that a server instance ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
The SHOW INDEX statement displays a cardinality value based on N/S, where N is the number of rows in the table and S is the average value group size. Storage engines collect statistics about tables for use by the optimizer. Table statistics are ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collation-character-set-applicability-table.html
Notes The COLLATION_CHARACTER_SET_APPLICABILITY columns are equivalent to the first two columns displayed by the SHOW COLLATION statement. The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of these tables, including data types and default values. The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-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_CMP and INNODB_CMP_RESET tables provide status information on ...