Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-blackhole.html
When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. The BLACKHOLE storage engine accepts data but discards it and does not store it. Updates and deletes are handled differently ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-limit.html
Statement-based replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT statements is unsafe since the order of the rows affected is not defined. (Such statements can be replicated correctly with statement-based replication only if ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-max-allowed-packet.html
This means that, when you are replicating large column values using row-based replication, you must take care to set max_allowed_packet large enough to accommodate the largest row in any table to be replicated, even if you are replicating updates ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-triggers.html
(Bug #45677) A trigger can have triggers for different combinations of trigger event (INSERT, UPDATE, DELETE) and action time (BEFORE, AFTER), and multiple triggers are permitted. With statement-based replication, triggers executed on the source ...
https://dev.mysql.com/doc/refman/9.7/en/replication-implementation.html
Tables are created or their structure modified, and data is inserted, deleted, and updated according to the changes that were originally made on the source. Replication is based on the source server keeping track of all changes to its databases ...
https://dev.mysql.com/doc/refman/9.7/en/revoke.html
For example: REVOKE INSERT ON *.* FROM 'jeffrey'@'localhost'; REVOKE 'role1', 'role2' FROM 'user1'@'localhost', 'user2'@'localhost'; REVOKE SELECT ON world.* FROM 'role3'; The host name part of the account or role name, if omitted, defaults to '%'.
https://dev.mysql.com/doc/refman/9.7/en/savepoint.html
(For a new inserted row, the lock information is carried by the transaction ID stored in the row; the lock is not separately stored in memory. SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/server-shutdown.html
If a thread is updating a nontransactional table, an operation such as a multiple-row UPDATE or INSERT may leave the table partially updated because the operation can terminate before completion. The server shutdown process takes place as follows: ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...
https://dev.mysql.com/doc/refman/9.7/en/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...