PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
To delete rows from selected partitions, use the TRUNCATE PARTITION option. TRUNCATE PARTITION merely deletes rows; it does not alter the definition of the table itself, or of any of its partitions. Partitioning-related clauses for ALTER TABLE can ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. A self-referential ON DELETE SET NULL, on the other hand, is possible, as is a ...If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
Deleted rows are put in a linked list and are reused when you insert new data into the table. MEMORY tables also have none of the problems commonly associated with deletes plus inserts in hashed tables. If a MEMORY table hash index has a high degree ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
deleting from main table The server is executing the first part of a multiple-table delete. It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables. deleting from reference ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
Avoid performing rollbacks after inserting, updating, or deleting huge numbers of rows. Set innodb_change_buffering=all so that update and delete operations are buffered in addition to inserts. Consider issuing COMMIT statements periodically during ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
The Key_writes/Key_write_requests ratio is usually near 1 if you are using mostly updates and deletes, but might be much smaller if you tend to do updates that affect many rows at the same time or if you are using the DELAY_KEY_WRITE table option.
https://dev.mysql.com/doc/refman/5.7/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, it bypasses the DML method of deleting data. Thus, it cannot be rolled back, it ...Truncate operations cause an implicit commit, and so cannot be rolled ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
2013-09-24T13:04:38.639684Z 49 [Note] Slave I/O thread: connected to master 'root@localhost:13000', replication started in log '0.000001' at position 114 Testing the InnoDB memcached Replication Configuration This example demonstrates how to test ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
DELETE: Logged as a DELETE_ROW event with all columns logged in the before image; the after image is not logged. DELETE: Logged as a DELETE_ROW event with primary key columns incuded in the before image; the after image is not logged. DELETE: Logged ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...