Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored in the InnoDB data dictionary. Cannot Open Datafile With innodb_file_per_table enabled (the default), the following messages may appear at startup if a file-per-table tablespace file (.ibd file) is ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Internal Versus External Credentials Storage Password Expiration Policy Password Reuse Policy Password Verification-Required Policy Dual Password Support Random Password Generation Failed-Login Tracking and Temporary Account Locking Important MySQL ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
If your database is stored in binary portable files, you can copy the raw data files to a replica. Choose one of these options: Exclude all the tables in the database using --ignore-table option. Check the description for mysqldump's ... If the ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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.4/en/mys-mysqlai-ml-predict-row.html
A table can include extra columns, and still use the MySQL HeatWave 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 ... ML_PREDICT_ROW generates predictions for one or more rows of unlabeled data specified in JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
Lakehouse Auto Parallel Load, which extends the Auto Parallel Load feature of MySQL HeatWave, facilitates the process of loading data from Object Storage into MySQL HeatWave by automating many of the steps involved, including: Excluding schemas, ...
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/8.4/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/8.4/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 ...