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-deadlock-example.html
The following example illustrates how an error can occur when a lock request causes a deadlock. Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
If your tables are primarily InnoDB tables, or if you have a mix of InnoDB and MyISAM tables, consider using mysqlbackup, which is available as part of MySQL Enterprise. (See Section 8.4.1.4, “Client-Side Cleartext Pluggable Authentication”.) ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...For ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The batched_key_access flag controls how the optimizer uses the Batched Key Access join algorithms. Optimizer hints ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Hash index pages: These are allocated as 8 KB subpages, and store the primary key hash index structure. Each row also has a primary key hash index entry (corresponding to the hidden primary key that is part of every NDB table). memory_per_fragment ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause ...If column b is also unique, the INSERT is equivalent to this UPDATE statement instead: UPDATE t1 SET c=c+1 WHERE a=1 OR b=2 LIMIT 1; If a=1 OR b=2 matches several rows, only one row is ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-rules.html
This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should be consulted for further information. MySQL recognizes a large enough subset of the syntax that, in many cases, it is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
For example, columns a and b are counted for the primary key index. For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-key-column-usage-table.html
This table provides no information about functional key parts because they are expressions and the table provides information only about columns. The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the ...CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint ...