PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
For example, the table switch in this example is valid: get @@aaa.AA BB VALUE @@aaa.AA 8 12 HELLO, HELLO VALUE BB 10 16 GOODBYE, GOODBYE END Attempting to switch tables again in the same get command to retrieve a key value from a different table is ... The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
The numeric values specified for this option correspond to isolation levels such as REPEATABLE READ. This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-next-key-locking.html
If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the table with an id of 101. InnoDB performs row-level locking ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. The Transportable Tablespaces ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
Phone numbers can be given in very different formats: +7-12345-67 +7-12-345-67 +7 12 345 67 +7 (12) 345 67 +71234567 The problem raised by dealing with these kinds of values is that the varying permissible formats make searching for a specific phone ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
This limits scalability when load increases, particularly for statement mixes that include writes. To enforce different size limits for MEMORY tables, change the value of this variable. You can set the size for individual tables as described later ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. It can also be used for queries that specify just a last_name value because that column is a leftmost prefix of the index (as ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
Use this for tables that are heavily used for searches but that are not updated. This feature enables you to assign different table indexes to different key caches. Any attempt to do this is ignored: mysql> SET GLOBAL key_buffer_size = 0; mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
This can also be changed by changing the source and recompiling. This is done by automatically combining adjacent deleted blocks and by extending blocks if the next block is deleted. myisamchk --fast checks only those tables that don't have this ...