Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
To use a dictionary, it must first be added to the masking_dictionaries system table and given a name. The dictionaries are read from the table and loaded to the cache during initialization of the components (on server startup). Note Always edit ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. This occurs even when ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system tablespace. You cannot define where within the system tablespace your tables are allocated. In a newly created ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-space-requirements.html
Temporary log files: A temporary log file records concurrent DML when an online DDL operation creates an index or alters a table. If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace-autoextend-size.html
By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following rules: If the tablespace is less than an extent in size, it is extended one page at a time. If ...
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/mysql-cluster-ndb-api-statistics.html
Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned scans; threads blocked while waiting for the completion of various operations; and data and events sent and ... A ...
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 ...