Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-columns.html
SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given table. These two statements are equivalent: SHOW COLUMNS FROM mytable ...SHOW COLUMNS displays information only for those columns for which you have some ...
https://dev.mysql.com/doc/refman/9.7/en/show-engine.html
Note InnoDB mutexes and rwlocks can also be monitored using Performance Schema tables. Interpret buffer names as follows: An internal buffer that is not exposed as a table is named within parentheses. An internal buffer that is exposed as a table in ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-bulk-load-mysql-server.html
Tables can have a combination of multiple stored and virtual generated columns. Support for bulk load into tables with existing data (non-empty tables). The bulk load operation compares the records from the input CSV files and the existing table, ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-predict-row.html
A table can include extra columns, and still use the AutoML model. This allows side by side comparisons of target column labels, ground truth, and predictions in the same table. The column names must match the feature column names in the table used ... ML_PREDICT_ROW generates predictions for one or more rows of unlabeled data specified in JSON ...
https://dev.mysql.com/doc/relnotes/mysql-shell/9.7/en/news-9-6-0.html
AdminAPI Added or Changed Functionality Utilities Added or Changed Functionality Utilities Bugs Fixed Functionality Added or Changed Bugs Fixed AdminAPI Added or Changed Functionality In previous releases, the periodic updates to the last_check_in ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-mta.html
Transaction Dependency and Writeset Handling Transaction dependencies are detected using analysis of each transaction's writeset, that is, the set of rows (table, key values) written by the transaction. Where a table has secondary unique keys, these ...To use this functionality with NDB Cluster, it is necessary that the replica be configured to use multiple worker ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for distribution among MySQL HeatWave nodes by default. Tip For data placement key recommendations, use MySQL HeatWave Autopilot Advisor ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-installation.html
$> mysql -u root -p -D mysql < audit_log_component_filter_install.sql Enter password: (enter root password here) It is possible to specify a custom database for storing JSON filter tables when you run the installation script. $> mysql -u root -p -D ... Note The Audit Log component is intended to replace the Audit Log plugin, which is now ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-and-mysql-replication.html
For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica. Cascading actions for InnoDB tables on the source are executed on the replica only if the tables sharing the foreign key relation use ...
https://dev.mysql.com/doc/refman/9.7/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do ...