Search Results
https://dev.mysql.com/doc/refman/8.4/en/regexp.html
For example, it can be specified as a string expression or table column. This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-sql-mode.html
If you are replicating partitioned tables, using different SQL modes on the source and the replica is likely to cause issues. At a minimum, this is likely to cause the distribution of data among partitions to be different in the source's and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transaction-inconsistencies.html
A transaction which updates non-transactional tables has applied some but not all of its changes. STOP REPLICA when the ongoing transaction updates transactional tables only, in which case it is rolled back and STOP REPLICA stops immediately. The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-db-options.html
Proceed to checking the table-level replication options, if there are any. For a description of how these options are checked, see Section 19.2.5.2, “Evaluation of Table-Level Replication Options”. The statement is not executed until all ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
Blocking also occurs after rollbacks that are written to the binary log, which occurs when a transaction that modifies nontransactional tables is rolled back. The rolled-back transaction is logged even though it has no effect for transactional ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-rbr-monitoring.html
When these Performance Schema instrument stages are enabled the events_stages_current table shows stages for applier threads and their progress. For background information, see Section 29.12.5, “Performance Schema Stage Event Tables”. The ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
RESET PERSIST affects the contents of the Performance Schema persisted_variables table because the table contents correspond to the contents of the mysqld-auto.cnf file. On the other hand, because RESET PERSIST does not change variable values, it ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
By extracting a session ticket from an established session and then submitting that ticket while establishing the next connection, the overall cost is reduced if the session can be reused. The following table shows the system variables that define ... MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime ...
https://dev.mysql.com/doc/refman/8.4/en/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 ...
https://dev.mysql.com/doc/refman/8.4/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.