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.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/5.7/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/5.7/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/5.7/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 MASTER statement, or a subset of them ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
The EVENT privilege governs the creation, modification, and deletion of events. In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. If a FOREIGN KEY constraint is defined on a table, any insert, update, or delete that requires the ...It ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
It does not contain any uncommitted values, old versions of values, or values marked for deletion but not yet removed from the old index. It merely deletes rows; it does not alter the definition of the table itself, or of any of its partitions.
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
14.8.11.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/5.7/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/5.7/en/innodb-transaction-isolation-levels.html
For locking reads (SELECT with FOR UPDATE or LOCK IN SHARE MODE), 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 ... Transaction isolation is one of the foundations of database ...