Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-user-attributes-table.html
The currently authenticated account has the UPDATE or SELECT privilege for the mysql.user system table. The USER_ATTRIBUTES table provides information about user comments and user attributes. The USER_ATTRIBUTES table has these columns: USER The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...Since changing ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-check-availability.html
Issue a SHOW ENGINES statement to view the available MySQL storage engines.
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuring-io-capacity.html
You can set the innodb_io_capacity value in the MySQL option file (my.cnf or my.ini) or modify it at runtime using a SET GLOBAL statement, which requires privileges sufficient to set global system variables. You can set the innodb_flush_sync value ...Before MySQL 8.4, this set it to the maximum value instead of the default ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-moving-data-files-offline.html
The innodb_directories variable can be specified in a startup command or MySQL option file. (Unix shells treat it as a command terminator, for example.) Startup command: mysqld --innodb-directories="directory_path_1;directory_path_2" MySQL option ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting.html
The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server error log (see Section 7.4.2, “The Error Log”). If the failure is related to a deadlock, run with ...Server Error Message Reference provides troubleshooting information for some of the common InnoDB-specific errors that you may ...
https://dev.mysql.com/doc/refman/8.4/en/insert-select.html
When selecting from and inserting into the same table, MySQL creates an internal temporary table to hold the rows from the SELECT and then inserts those rows into the target table. See Section 10.4.4, “Internal Temporary Table Use in MySQL”, and ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/integer-types.html
MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. The following table shows the required storage and range for each ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Type String The destination keyring plugin or component for key migration. For ...The option value interpretation depends on whether --keyring-migration-to-component or --keyring-migration-from-component is specified: If --keyring-migration-to-component is used, the option value is a keyring plugin, interpreted the same way as for ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL currently interprets the reference as the name of a variable. MySQL interprets this as a reference to the variable of that name rather than a ...