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/concurrent-inserts.html
If the variable is set to ALWAYS (or 2), concurrent inserts at the end of the table are permitted even for tables that have deleted rows. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
If you are using a nontransactional storage engine, MySQL stops processing the statement at the row for which the error occurred and leaves any remaining rows unprocessed. If you use it, MySQL ignores primary-key or unique-key violations and ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
row *************************** EXPLAIN: -> Index scan on t1 using a_desc_b_asc (reverse) (cost=0.35 rows=1) See also EXPLAIN Extra Information. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
Assume that referential integrity has been accidentally broken and there exists a row of countrylanguage without a corresponding row in country. The following discussion provides several examples of the ways in which MySQL detects functional ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-privileges-table.html
Each row lists a single privilege, so there is one row per column privilege held by the grantee. The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT OPTION'. The COLUMN_PRIVILEGES table has these columns: GRANTEE The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-deleted-table.html
The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB table. The INNODB_FT_DELETED table has these columns: DOC_ID The document ID of the newly deleted row. This value is used when you perform text searches, ...Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
If the amount of data in an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an update operation, InnoDB attempts to merge the index page with the neighboring index page. row ...For related usage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
When a memcached operation inserts, updates, or deletes data in the underlying InnoDB table, the change might be committed to the InnoDB table instantly (if daemon_memcached_w_batch_size=1) or some time later (if the daemon_memcached_w_batch_size ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-schema.html
+-------------------------------------------------------+---------+-------+ 155 rows in set (0.00 sec) For additional information about the instrumented InnoDB objects, you can query Performance Schema instances tables, which provide additional ...