Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backup-details.html
DELETING: The backup is being deleted by a delete action in the Console. DELETED: The backup has been deleted and is no longer available. Backup Details 18.3.1 Backup Details Use the Console to view the Backup Details page, which contains the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-privatelink-details.html
DELETED: The PrivateLink has been deleted and is no longer available. PrivateLink Details 6.3.5.1 PrivateLink Details The PrivateLink Details page has the following tabs: Table 6-3 Tabs on the PrivateLink Details Page Name Description Details ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
For example, you can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. Subsequently, NDB deletes the old table and renames the new one. After alterations are applied to the ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Example: <SQLTEXT>DELETE FROM t1</SQLTEXT> <STARTUP_OPTIONS> A string representing the options that were given on the command line or in option files when the MySQL server was started. Example: SQLTEXT="DELETE FROM t1" STARTUP_OPTIONS A string ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
The description for the PURGE BINARY LOGS statement explains what should be verified before deleting the MySQL binary logs. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is used. You can delete all binary log files with the RESET BINARY LOGS AND GTIDS statement, or a ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
17.8.10.1.4 Including Delete-marked Records in Persistent Statistics Calculations By default, InnoDB reads uncommitted data when calculating statistics. In the case of an uncommitted transaction that deletes rows from a table, delete-marked records ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
InnoDB does not physically remove a row from the database immediately when you delete it with an SQL statement. A row and its index records are only physically removed when InnoDB discards the undo log record written for the deletion. When the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, locking depends on whether the statement uses a unique index with a unique search condition, or a range-type search condition. It is not recommended to mix ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
Holes can result from rows having been deleted from or updated in the middle of the table. This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...