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/information-schema-innodb-sys-tablestats-table.html
Table statistics are updated only for DELETE or UPDATE operations that modify indexed columns. The value could be imprecise if uncommitted transactions are inserting into or deleting from the table. MODIFIED_COUNTER The number of rows modified by ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
The value might include delete-marked rows that are physically present but not visible to the transaction. The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
The flag is set to YES (true) if UPDATE and DELETE (and similar operations) are legal for the view. If a view is not updatable, statements such UPDATE, DELETE, and INSERT are illegal and are rejected. If the IS_UPDATABLE value for a view has become ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
Since MySQL can “delete-mark” and delete rows on compressed pages “in place” by modifying uncompressed data, DELETE operations on a table are relatively efficient. Most often, the internal optimizations described in InnoDB Data Storage and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
You can get deadlocks even in the case of transactions that just insert or delete a single row. That is because these operations are not really “atomic”; they automatically set locks on the (possibly several) index records of the row inserted or ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
If the amount of data in an index page falls below the this value (the default is 50%) when a row is deleted or when a row is shortened by an update operation, InnoDB attempts to merge the index page with a neighboring index page. In this case, the ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
Purge Deleting delete-marked records that are no longer visible to active transactions. Redo logs for missing tablespace *.ibd files are only disregarded if there is a file-delete redo log record (MLOG_FILE_DELETE) in the log. For example, a table ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
If the kill flag was set, the statement is aborted and the temporary table is deleted. During UPDATE or DELETE operations, the kill flag is checked after each block read and after each updated or deleted row. KILL [CONNECTION | QUERY] ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
If the data file contains everything that it should and the delete links point at the correct locations within the data file, this should work, and the table is fixed. This removes incorrect rows and deleted rows from the data file and reconstructs ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
This includes all inserts, updates, writes and deletes, as well as writes performed as part of unique index operations. The Operations statistic provides the number of local operations performed by this LQH block in the last reporting interval, and ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...