PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html
If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment column. Auto-increment column values are unique and are added automatically as new rows are inserted. If you do not define a PRIMARY ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Gap locking is not needed for statements that lock rows using a unique index to search for a unique row. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. If the memcached server is used for multiple applications, or with more than one InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, locking depends on whether the statement uses a unique index with a unique search condition, or a range-type search condition. For a unique index with a unique ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
For example, an index continues to be updated per changes to table rows, and a unique index prevents insertion of duplicates into a column, regardless of whether the index is visible or invisible. A table with no explicit primary key may still have ... MySQL supports invisible indexes; that is, indexes that are not used by the ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
With IGNORE, new rows that duplicate an existing row on a unique key value are discarded. If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). The file can be read from the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
(NDB 8.0.13) Each node in the cluster has a unique identity. This ID is used by all internal cluster messages for addressing the node, and so must be unique for each NDB Cluster node, regardless of the type of node. (NDB 8.0.13) Each node in the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
MaxNoOfUniqueHashIndexes: Total number of unique hash indexes that can be defined in system. MaxUIBuildBatchSize: Maximum scan batch size to use for building unique keys. Increasing this value may speed up builds of unique keys but impacts ongoing ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
You should use this option prior to inserting new rows into the database; otherwise, it is possible for a row to be inserted that later causes a unique constraint violation when trying to rebuild the indexes. Rebuilding of unique indexes uses disk ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
--repair, -r Command-Line Format --repair Perform a repair that can fix almost anything except unique keys that are not unique. The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is ...