PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/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.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). Primary key values are included in secondary indexes, which takes up unnecessary space if the ...If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
ReservedTransactionBufferMemory: Dynamic buffer space (in bytes) for key and attribute data allocated to each data node. ReservedTransactionBufferMemory: Dynamic buffer space (in bytes) for key and attribute data allocated to each data node.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name ... Note ...