Search Results
https://dev.mysql.com/doc/refman/9.7/en/not-enough-file-handles.html
To tell mysqld to keep open fewer files at a time, you can make the table cache smaller by reducing the value of the table_open_cache system variable (the default value is 64). This may not entirely prevent running out of file descriptors because in ... If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/option-tracker-component-status-variables.html
option_tracker.gr_complete_table_received This is the number of complete tables which have been received through Group Replication. option_tracker.gr_complete_table_sent This is the number of complete tables which have been sent through Group ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...