PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
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 + 1. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ...The ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
For example, a WKB value that corresponds to POINT(1 -1) consists of this sequence of 21 bytes, each represented by two hexadecimal digits: 0101000000000000000000F03F000000000000F0BF The sequence consists of the components shown in the following ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
If a specific query kills mysqld and the tables involved were checked with CHECK TABLE before you ran the query, can you provide a reproducible test case? See Section 5.8, “Debugging MySQL”. This section also covers the related Lost connection ...
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/group-replication-system-variables.html
These conditions apply to the following system variables: group_replication_single_primary_mode group_replication_enforce_update_everywhere_checks group_replication_gtid_assignment_block_size default_table_encryption lower_case_table_names ... This ...
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 ...