Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/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/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Dyn: Whether the item is dynamically settable while the server is running. An item has a row in the table if it ever existed in any series shown in the table. Intr: ...
https://dev.mysql.com/doc/refman/9.7/en/function-optimization.html
If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when selecting from one table) or combination of rows (when selecting from a multiple-table join). MySQL also determines when to evaluate ...A ...
https://dev.mysql.com/doc/refman/9.7/en/set-variable.html
This makes PERSIST_ONLY suitable for configuring read-only system variables that can be set only at server startup. The Performance Schema variables_info table contains information showing when and by which user each system variable was most ...