Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
That is, MySQL explains how it would process the statement, including information about how tables are joined and in which order. With the help of EXPLAIN, you can see where you should add indexes to tables so that the statement executes faster by ... The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
Note that before starting mysqld with the general query log enabled, you should check all your tables with myisamchk. If this happens, you should check all your tables with myisamchk (see Chapter 7, MySQL Server Administration), and test the ...If ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location. DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
Creating Incremental Backups Using Only the Redo Log The --incremental-with-redo-log-only might offer some benefits over the --incremental option for creating an incremental backup: The changes to the InnoDB tables are determined based on the ...In ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-use-tts.html
Requirements for restoring backups created with transportable tablespaces (TTS) (that is, created with the --use-tts option) are similar to those listed in Section 5.1.4, “Table-Level Recovery (TLR)”, with some differences noted in the section.
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-autocompletion.html
Autocompletion supports the following text objects: In SQL mode, autocompletion is aware of schema names, table names, column names of the current active schema. SELECT schema1.table1.column1 FR: the prefix is 'FR', no qualifier is present. For ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-classification-generate-explanation.html
Generating Prediction Explanations for a Table After training a model, you can generate a table of prediction explanations on the testing_data dataset by using the default Permutation Importance prediction explainer. To generate explanations for ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-metrics.html
If the input table overlaps with the training table, and remove_seen is true, which is the default setting, then the model will not repeat a recommendation and it ignores the overlap items. The precision_at_k value for the input table is the average ... The ML_TRAIN routine includes the optimization_metric option, and the ML_SCORE routine includes the metric ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
For this reason, this facility can be switched off for models containing large numbers of schemas and tables. Figure 3.8 Preferences: SQL Editor: Object Editors Online DDL Default algorithm for ALTER table: [ Default ] Sets the default algorithm ...