Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
In this release, the use of any such columns in the proposed partitioning key is now expressly disallowed, and causes the CREATE TABLE or ALTER TABLE statement in which it occurs to be rejected with an error. Attempting to use these together in ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.partial.html
Table-Level Recovery (TLR) allows selected tables (or schemas) to be restored from a backup (be it a full backup, a partial backup, or a backup created using transportable tablespaces (TTS)) using the --include-tables and --exclude-tables options.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
Even when the Performance Schema is disabled, it continues to populate the global_variables, session_variables, global_status, and session_status tables. This occurs as necessary to permit the results for the SHOW VARIABLES and SHOW STATUS ...The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-generate-table.html
If the specified output table doesn't exist, then a new table is created. The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in parallel. This topic contains the following sections: ML_GENERATE_TABLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
Create a session variable with the characteristics of the input_list to create the external table and specify the files to load into the table. Run the HEATWAVE_LOAD command to create the external table and load the data into the table. mysql> CALL ... Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external ...This topic contains the following sections: Before You Begin Refresh Data Overview Perform Initial Load ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. For optimal performance when loading data into an InnoDB FULLTEXT index, ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR TABLE statements. It is also a good idea to enable automatic MyISAM ...The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these columns: table_schema The schema that contains the table. total_latency The ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. Row-Level Locking Table-Level Locking Choosing the Type of Locking Row-Level Locking ...