Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
The VICTIM, TIMEOUT, and KILLED status values are brief and signify that the lock row is about to be deleted. MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
Rows can be inserted into or deleted from setup_objects by users with the INSERT or DELETE privilege on the table. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
SQL statements are expressed as text, such as DELETE FROM t1 or SELECT * FROM t2. Instruments for SQL statements have names that begin with statement/sql, such as statement/sql/delete and statement/sql/select. Statement events occur at a high level ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
For example, columns that aggregate all writes hold the sum of the corresponding columns that aggregate inserts, updates, and deletes. They are the same as the sum of the corresponding xxx_INSERT, xxx_UPDATE, and xxx_DELETE columns. COUNT_DELETE, ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-mysql-sock.html
(For some distribution formats, the directory might be different, such as /var/lib/mysql for RPMs.) On some versions of Unix, anyone can delete files in the /tmp directory or other similar directories used for temporary files. On most versions of ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
Telling the server to ignore the .MYI file makes important table metadata stored in the .MYI unavailable to the repair process, which can have deleterious consequences: The current AUTO_INCREMENT value is lost. The link to deleted records in the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-key-rotation.html
If a retained binary log file or relay log file cannot be initialized for re-encryption, the relevant binary log encryption keys are not deleted in case the files can be recovered in the future. If the server UUID changes, for example because a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-blackhole.html
Updates and deletes are handled differently depending on whether statement based or row based logging is in use. When using row-based logging, updates and deletes to such tables are simply skipped—they are not written to the binary log. The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
asynchronous_connection_failover_delete_managed() Remove an entire managed group from the source list for a replication channel. Syntax: asynchronous_connection_failover_delete_managed(channel, managed_name) Arguments: channel: The replication ...