PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-observability.html
The entire state of the system (including the view, conflict statistics and service states) can be queried through performance_schema tables. For example, you can connect to a single server in the group and obtain both local and global information ... There is a lot of automation built into the Group Replication ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily for disk seek operations) compared to flushing individual pages at different times. For table data stored on SSD, ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuration.html
For information about optimizing database operations for InnoDB tables, see Section 8.5, “Optimizing for InnoDB Tables”. This section provides configuration information and procedures for InnoDB initialization, startup, and various components ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-developing.html
Coming from a database background, you might be used to general-purpose SQL tables with many columns. The tables accessed by memcached code likely have only a few or even a single column holding data values. Typically, writing an application for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
This information is stored in the system tablespace or undo tablespaces in a data structure called a rollback segment. Otherwise, InnoDB cannot discard data from the update undo logs, and the rollback segment may grow too big, filling up the ...It ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction. You ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...
https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
The following table shows the required storage and range for each integer type. MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, ...
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
This optimization does not occur in cases when the column might produce NULL anyway (for example, if it comes from a table on the right side of a LEFT JOIN). MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
MySQL recognizes the escape sequences shown in Table 12.23, “JSON_UNQUOTE() Special Character Escape Sequences”. The functions in this section modify JSON values and return the result. JSON_APPEND(json_doc, path, val[, path, val] ...) Appends ...