PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. Temporary tables are dropped automatically when a replica ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-configuration.html
A multi-source replication topology requires at least two sources and one replica configured. In these tutorials, we assume you have two sources source1 and source2, and a replica replicahost. The replica replicates one database from each of the ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
Row-Level Locking Table-Level Locking Choosing the Type of Locking Row-Level Locking MySQL uses row-level locking for InnoDB tables to support simultaneous write access by multiple sessions, making them suitable for multi-user, highly concurrent, ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. row *************************** OBJECT_TYPE: LOCKING SERVICE OBJECT_SCHEMA: ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
If transaction T1 holds a shared (S) lock on row r, then requests from some distinct transaction T2 for a lock on row r are handled as follows: A request by T2 for an S lock can be granted immediately. A request by T2 for an X lock cannot be granted ...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) ...
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
For example: $> mysql -h host -u user -p menagerie Enter password: ******** Important menagerie in the command just shown is not your password. However, putting your password on the command line is not recommended, because doing so exposes it to ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. Log in to the OCR with your Docker client (the docker command) using the docker login command: # docker login ... Warning The MySQL ...