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/create-tablespace.html
Also, the physical page size of the compressed table (KEY_BLOCK_SIZE) must be equal to FILE_BLOCK_SIZE/1024. For example, if innodb_page_size=16K, and FILE_BLOCK_SIZE=8K, the KEY_BLOCK_SIZE of the table must be 8. The FILE_BLOCK_SIZE of 8192 ...The ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
row *************************** id: 1 select_type: PRIMARY table: <derived2> partitions: NULL type: system possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row ... A derived ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
Note For a multiple-row insert, LAST_INSERT_ID() and mysql_insert_id() actually return the AUTO_INCREMENT key from the first of the inserted rows. For example, if the animals table contained indexes PRIMARY KEY (grp, id) and INDEX (id), MySQL would ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-locks-table.html
Primary key values of the locked record are shown for a lock placed on the primary key index. Secondary index values are shown with primary key values appended if the secondary index is not unique. If there is no primary key, LOCK_DATA shows either ... The INNODB_LOCKS table provides information about each lock that an InnoDB transaction has requested but not yet acquired, and each lock that a transaction holds that is blocking another ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
PARTITION_METHOD One of the values RANGE, LIST, HASH, LINEAR HASH, KEY, or LINEAR KEY; that is, one of the available partitioning types as discussed in Section 22.2, “Partitioning Types”. SUBPARTITION_METHOD One of the values HASH, LINEAR HASH, ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
Data Characteristics and Compression A key determinant of the efficiency of compression in reducing the size of data files is the nature of the data itself. It might be that the primary key (clustered) index, which contains the data for all columns ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
The way InnoDB does fast primary key lookups is a natural fit for memcached single-item queries. The direct, low-level database access path used by the daemon_memcached plugin is much more efficient for key-value lookups than equivalent SQL queries.
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
Use the set command to insert a record with a key of test1, a flag value of 10, an expiration value of 0, a cas value of 1, and a value of t1. The example record with a key of AA, and the record you just inserted, with a key of test1. The c1 column ... Because the daemon_memcached plugin supports the MySQL binary log, updates made on a source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, such as a numeric type instead of a string type, attempts to store key-value pairs fail with no specific error code or message. As the length ... This section describes issues that you may encounter when using the InnoDB memcached ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html
[ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} assignment: col_name = value assignment_list: assignment [, assignment] ... SELECT statements: Specify IGNORE to ignore rows that would cause duplicate-key violations. ON DUPLICATE ...