Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain.html
The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide information about tables. MySQL 8.4 supports an additional INTO option with EXPLAIN FORMAT=JSON, which enables saving the JSON formatted output into a user variable, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
The patterns of values in your data determine how well it compresses, but typical user data often compresses by 50% or more. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prereqs.html
The model catalog schema created by the ML_TRAIN procedure incorporates the user name in the schema name (for example, ML_SCHEMA_joesmith), and a period is not a permitted schema name character. MySQL User Names To use MySQL HeatWave AutoML, ensure ...Model and Table Sizes The table used to train a model cannot exceed 10 GB, 100 million rows, or 1017 ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
Note A local cloning operation does not support cloning of user-created tables or tablespaces that reside outside of the data directory. All other user-created InnoDB tables and tablespaces, the InnoDB system tablespace, redo logs, and undo ...The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. SLAVE indicates that the tablespace is allocated for storing user-created temporary tables on a ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ... In particular, INSERT or UPDATE statements ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
preparable_stmt is either a string literal or a user variable that contains the text of the SQL statement. The scope of a prepared statement is the session within which it is created, which as several implications: A prepared statement created in ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
A passphrase containing multiple words is easy to create, remember, and reproduce, and is much more secure than a typical user-selected password consisting of a single modified word or a predictable sequence of characters. MySQL uses security based ... Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-encrypted-connections.html
Encryption per connection is optional, but a specific user can be required to use encryption for X Protocol and MySQL Protocol connections by including an appropriate REQUIRE clause in the CREATE USER statement that creates the user. Alternatively, ... This section explains how to configure X Plugin to use encrypted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-scheduled-backups.html
Outputs from the stderr and stdout streams are redirected to /dev/null/, so they will not invoke other actions on the part of the Cron server (for example, email notifications to the user). Maintaining a regular backup schedule is an important ...