Search Results
https://dev.mysql.com/doc/refman/8.4/en/online-ddl-parallel-thread-configuration.html
Parallel scan is not supported on tables defined with virtual columns. Parallel scan is not supported on tables defined with a full-text index. Parallel scan is not supported on tables defined with a spatial index. The default setting is calculated ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
When rows are modified or deleted within a long-running transaction, other transactions using the READ COMMITTED and REPEATABLE READ isolation levels have to do more work to reconstruct the older data if they read those same rows. When a ... To ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-build-configuration.html
If you install MySQL over a previous installation that was configured without the Performance Schema (or with an older version of the Performance Schema that has missing or out-of-date tables). One indication of this issue is the presence of ...It ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. However, the content of the tables in the performance_schema database misses events. For example, ...Names ...
https://dev.mysql.com/doc/refman/8.4/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. Assign passwords to the initial root account in the grant tables, if that was not already ...
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 ...