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/mysqldump.html
You can clone databases for development and DBA work, or produce slight variations of an existing database for testing. If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise ... The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
If in_table is NULL and no snapshot exists, a new snapshot is created. The delta is calculated between the reference table specified by in_table and the snapshot, which must exist. This view must be specified using the ... Creates a report of the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
To affect trigger order, specify a clause after FOR EACH ROW that indicates FOLLOWS or PRECEDES and the name of an existing trigger that also has the same trigger event and action time. First, the triggers that exist on a source must be re-created ...Where can I find the documentation for MySQL 5.7 triggers? ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
For tables which are partitioned by RANGE, this can be used to add a new range to the end of the list of existing partitions. The general syntax for REORGANIZE PARTITION is shown here: ALTER TABLE tbl_name REORGANIZE PARTITION partition_list INTO ...
https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html
The next steps depend on whether you have existing data to import to the replica or not. If you have a snapshot of a database to import, see Section 16.1.2.5.4, “Setting Up Replication with Existing Data”. This method can also be used if you are ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Now it can be enabled and replication-safe user management performed with CREATE USER IF NOT EXISTS, DROP USER IF EXISTS, and ALTER USER IF EXISTS rather than GRANT. Rows that duplicate an existing row on a unique key value are discarded. INSERT: ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ... It enables authentication, SSL/TLS, resource-limit, and password-management properties to be modified for existing accounts. By default, an error occurs if you try to modify a ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
Trigger names exist in the schema namespace, meaning that all triggers must have unique names within a schema. To affect trigger order, specify a trigger_order clause that indicates FOLLOWS or PRECEDES and the name of an existing trigger that also ... CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } other_trigger_name This statement creates a new ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
Existing sessions continue to use the cost estimates that were current when they began. If no channel is named and no extra replication channels exist, the operation applies to the default channel. If no channel is named and multiple replication ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
Intention Locks InnoDB supports multiple granularity locking which permits coexistence of row locks and table locks. X IX S IS X Conflict Conflict Conflict Conflict IX Conflict Compatible Conflict Compatible S Conflict Conflict Compatible Compatible ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...