PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
In MySQL, the specific task of generating a unique identifier actually can be accomplished using only a single access to the table: UPDATE child_codes SET counter_field = LAST_INSERT_ID(counter_field + 1); SELECT LAST_INSERT_ID(); The SELECT ... If ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-tuning.html
It can also be used to generate sample key-value pairs to use in your own benchmarks. Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-compression-oltp.html
If you are certain that the zlib version is not likely to change, disable innodb_log_compressed_pages to reduce redo log generation for workloads that modify compressed data. Traditionally, the InnoDB compression feature was recommended primarily ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. A transaction ID is only needed for a transaction that might perform write operations or locking reads such ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
That number is generated by randomly selecting an integer ranging from 0 up to but not including the innodb_spin_wait_delay value, and multiplying that value by 50. InnoDB mutexes and rw-locks are typically reserved for short intervals. On a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
The temporary tablespace receives a dynamically generated space ID when it is created. Non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a shared temporary tablespace. The innodb_temp_data_file_path ...
https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html
The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT DELAYED is no longer supported. The DELAYED option for the INSERT statement is a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html
Two aggregate functions generating JSON values are available (MySQL 5.7.22 and later). The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
Otherwise, an error occurs: ERROR 1123 (HY000): Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed. Otherwise, an error occurs: ERROR 3188 (HY000): Function 'keyring_key_generate' ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-plugin-specific.html
AWS KMS maintains previous CMK versions, so keys generated using previous CMKs remain decryptable after rotation. For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information ...