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/identifiers.html
Section 9.2.1, “Identifier Length Limits”, indicates the maximum length of each type of identifier. The identifier quote character is the backtick (`): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O thread. max_allowed_packet ... max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
The output of mysqladmin processlist and SHOW PROCESSLIST shows the text of any statements currently being executed, so any user who is permitted to see the server process list might be able to see statements issued by other users such as UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
The column is also indexed and the optimizer can take that index into account during execution plan construction. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
IS_UPDATABLE MySQL sets a flag, called the view updatability flag, at CREATE VIEW time. You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs.
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
Attempting to create an index on any other column results in an error. ARCHIVE does not support inserting a value into an AUTO_INCREMENT column less than the current maximum column value. A bulk insert is visible only after it completes, unless ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. This can be the name of a clustered index or a secondary index. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Note This needs to be done only for tables already existing at the time the new node ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/sys-processlist.html
time The time in seconds that the thread has been in its current state. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. By default, rows are sorted by descending process ...They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
A replication group is formed by multiple servers and each server in the group may execute transactions independently at any time. However, there may be conflicts between transactions that execute concurrently on different servers. During ... Group ...