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/built-in-function-reference.html
For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. The following table lists each built-in (native) function and operator and provides a short description of each one. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
For example, if during the course of executing statements for a table, some of those statements modify the table, MySQL may collect statistics. (This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If you encounter a full-table error, there are several reasons why it might have occurred: The ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
This section is for the cases where a table check fails (such as those described in Section 7.6.2, “How to Check MyISAM Tables for Errors”), or you want to use the extended features that myisamchk provides. Stage 1: Checking your tables Run ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
COLUMN_KEY Whether the column is indexed: If COLUMN_KEY is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, nonunique index. on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
As with INSERT, if it is not possible to insert the new row into any of these partitions or subpartitions, the REPLACE statement fails with the error Found a row not matching the given partition set. such statements produce a warning in the error ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...For ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-group-membership.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. Every server in the group has a consistent view of which servers are the members participating actively in the group at a given moment in time.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
(You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that has a size of 128KB, with the size of block buffers for caching table index blocks set to 2048 bytes. The ... A ...