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/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/innodb-information-schema-internal-data.html
This buffer is refreshed only if more than 0.1 seconds has elapsed since the last time the buffer was read. The data needed to fill the three tables is fetched atomically and consistently and is saved in this global internal buffer, forming a ...
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/disk-issues.html
This makes both the seek and read times better, assuming that the disk is not used for other purposes as well. Striping Striping means that you have many disks and put the first block on the first disk, the second block on the second disk, and the ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...
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/xa-statements.html
If you use any of those statements but specify an xid value that does not correspond to some existing XA transaction, an error occurs. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid ...
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/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/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT * FROM performance_schema.setup_instruments; ... Events ...