Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-metadata-locks-table.html
When a metadata lock is requested and not obtained immediately, a row with a status of PENDING is inserted. MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-table-handles-table.html
The value is one of READ, READ WITH SHARED LOCKS, READ HIGH PRIORITY, READ NO INSERT, WRITE ALLOW WRITE, WRITE CONCURRENT INSERT, WRITE LOW PRIORITY, or WRITE. The Performance Schema exposes table lock information through the table_handles table to ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-create-select.html
ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. If the destination table exists and IF NOT EXISTS is given, MySQL 9.7 ignores the statement completely; nothing is inserted or logged. SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-errors.html
This can happen, for example, on a multiple-row insert that has one row violating a key constraint, or if a long update statement is killed after updating some of the rows. For example, since MyISAM ignores foreign key constraints, an INSERT or ...
https://dev.mysql.com/doc/refman/9.7/en/replication-functions-async-failover.html
Example: SELECT asynchronous_connection_failover_add_managed('channel2', 'GroupReplication', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '127.0.0.1', 3310, '', 80, 60); ... The following functions enable you to add or remove replication source servers ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks-account.html
In order to execute specific replicated transactions from the relay log, or transactions from mysqlbinlog output as required, the PRIVILEGE_CHECKS_USER account must have the following privileges: For a row insertion logged in row format (which are ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-data-metadata.html
If the result set is not empty, the contents of each row are printed in the order obtained; otherwise, the function gets the number of rows affected by the statement and the value of the last inserted ID. This includes the names of the columns in ...
https://dev.mysql.com/doc/refman/9.7/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Connect Used by replication receiver threads connected to the source, and by replication ...
https://dev.mysql.com/doc/refman/9.7/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...