Search Results
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. To delete all ...Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table ...
https://dev.mysql.com/doc/refman/8.4/en/deleting-from-related-tables.html
If the total length of the DELETE statement for related_table is more than the default value of the max_allowed_packet system variable, you should split it into smaller parts and execute multiple DELETE statements. You probably get the fastest ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-deleting-remotely-monitored-target.html
To delete a target, do the following: Navigate to the remotely-monitored target's homepage. From the MySQL Database menu, select Remove Target from the Target Setup menu. Note Removing a target does not undeploy the plugin from the management ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
These values could result from SQL INSERT, UPDATE, or DELETE statements (DML). The set of features involving the change buffer is known collectively as change buffering, consisting of insert buffering, delete buffering, and purge buffering. See Also ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete ...rs.Open "SELECT * FROM my_ado", conn Debug.Print rs.RecordCount rs.MoveFirst Debug.Print String(50, "-") & "Updated my_ado Result Set " & String(50, "-") For Each fld In rs.Fields Debug.Print fld.Name, Next Debug.Print Do Until rs.EOF For Each fld In rs.Fields Debug.Print fld.Value, Next rs.MoveNext Debug.Print Loop rs.Close conn.Close End ...
https://dev.mysql.com/doc/internals/en/delete-row.html
Synopsis virtual int delete_row ( buf); const byte * buf ; Description This is the delete_row method. buf will contain a copy of the row to be deleted. If you keep a pointer to the last row or can access a primary key it will make doing the deletion ...The server will call this right after the current row has been called (from either a previous rnd_next() or index ...
https://dev.mysql.com/doc/internals/en/delete-table.html
Synopsis virtual int delete_table ( name); const char * name ; Description This is the delete_table method. By the time delete_table() has been called all opened references to this table will have been closed (and your globally shared references ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/information-schema-innodb-ft-being-deleted-table.html
The INNODB_FT_BEING_DELETED table provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are ...
https://dev.mysql.com/doc/internals/en/delete-file-event.html
Binlog::DELETE_FILE_EVENT: Payload 4 file_id ...