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-memcached-internals.html
In this case, if memcached cannot find a key in memory, it searches for the value in an InnoDB table. For example, if you define col1, col2 as value columns, and you define | as the separator, you can issue the following memcached command to insert ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
For ANALYZE TABLE operations that update the key distribution, failure may occur even if the operation updates the table itself (for example, if it is a MyISAM table). If the index is the primary key, the name is always PRIMARY. EXPRESSION MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
The single row of data in the demo_test table has a key value of AA. When you restart MySQL, get operations once again return the key-value pairs you stored in the earlier memcached session. When a key is requested and the associated value is not ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
Unique key reads have their locks upgraded automatically by NDB to ensure a self-consistent read; BLOB reads also employ extra locking for consistency. You can help minimize issues with shared read locks by avoiding queries that use unique key ... A ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. row *************************** Table: city Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: ID ...This statement requires some privilege for any column in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
The index is not required to be a PRIMARY KEY or UNIQUE, but to avoid duplicate values in the AUTO_INCREMENT column, those index types are recommended. ON DUPLICATE KEY UPDATE, which in the worst case is in effect an INSERT followed by a UPDATE, ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
One way to make collisions detectable is to make the hash column a primary key. AES_DECRYPT(crypt_str,key_str[,init_vector][,kdf_name][,salt][,info | iterations]) This function decrypts data using the official AES (Advanced Encryption Standard) ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
The conditions for use of SQL_CALC_FOUND_ROWS with UNION are: The SQL_CALC_FOUND_ROWS keyword must appear in the first SELECT of the UNION. ON DUPLICATE KEY UPDATE statements, the affected-rows value per row is 1 if the row is inserted as a new row, ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
If you have UNIQUE constraints on secondary keys, you can speed up table imports by temporarily turning off the uniqueness checks during the import session: SET unique_checks=0; ... If you have FOREIGN KEY constraints in your tables, you can speed ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. ON DUPLICATE KEY UPDATE statements on tables with multiple primary or unique keys.