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/storage-engines.html
InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data. Storage engines are MySQL components that handle the SQL operations for different table types.
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
The events_transactions_current table displays the current status of the most recent monitored transaction event on the thread, and does not update this status when the thread is idle. If two XA transactions committed in parallel on the source are ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
LOCK IN SHARE MODE causes shared row locks to be used; FOR UPDATE causes exclusive row locks to be used. When a row referenced by a unique index in the user-created NDB table is updated, the hidden index table is subject to an exclusive lock by the ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
You need to understand the release model for MySQL innovation and long-term support (LTS) versions before you proceed with an upgrade. When the client program connects, the server places the client session in sandbox mode if the device must be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
It uses Electronic Codebook (ECB) block encryption mode for tablespace key encryption and Cipher Block Chaining (CBC) block encryption mode for data encryption. Enable the stage/innodb/alter tablespace (encryption) instrument: mysql> USE ... InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
(This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Any TIMESTAMP or DATETIME column in a table can have automatic initialization and updating properties; see Section 13.2.5, “Automatic Initialization ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded InnoDB. InnoDB API functions are passed to the InnoDB memcached engine as callback ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
row *************************** database_name: sakila table_name: actor last_update: 2014-05-28 16:16:44 n_rows: 200 clustered_index_size: 1 sum_of_other_index_sizes: 1 ...mysql> SELECT * FROM innodb_index_stats \G *************************** 1. row ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-native.html
Note Before installing, make sure that you update your apt-get index files to ensure you are downloading the latest available version. Many Linux distributions include a version of the MySQL server, client tools, and development components in their ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. After ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...