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/innodb-locking.html
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 ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
Here is a simple example that associates a trigger with a table, to activate for INSERT operations. The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
For example, this statement grants the SELECT and INSERT privileges globally: GRANT SELECT, INSERT ON *.* TO u1; The globally granted privileges apply to all databases, tables, and columns, even though not granted at any of those lower levels. To ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
You might increase this value for a MySQL server with heavy insert, update, and delete activity, or decrease it for a MySQL server with unchanging data used for reporting. innodb_change_buffering Command-Line Format --innodb-change-buffering=value ... System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT Statements”. For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if ...With some extra work, it is possible to make LOAD DATA run even faster for a MyISAM table when the table has many ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples.html
The following INNODB_LOCKS and INNODB_LOCK_WAITS tables show that: Transaction 77F (executing an INSERT) is waiting for transactions 77E, 77D, and 77B to commit. Transaction 77E (executing an INSERT) is waiting for transactions 77D and 77B to commit. Transaction 77D (executing an INSERT) is waiting for transaction 77B to ... Identifying Blocking ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
NDB applies WRITE_ROW events strictly as inserts, requiring that there is not already any such row; that is, an incoming write is always rejected if the row already exists. Both NDB$EPOCH() and NDB$EPOCH_TRANS() insert entries for conflicting rows ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including circular replication), it is possible that different sources may try to update the same row on the replica with different ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. For another MySQL extension to standard SQL—that ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
If you insert a row into a table partitioned by RANGE such that the column value used to determine the partition is NULL, the row is inserted into the lowest partition. A row with a dt column value of NULL is treated as though the partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
While a transaction is open, the system keeps a snapshot of the data as seen at the beginning of the transaction, which can cause substantial overhead if the system inserts, updates, and deletes millions of rows while a stray transaction keeps ...