Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
When Step 2 is upgrading the system tables in the mysql schema, the column order in the primary key of the mysql.db, mysql.tables_priv, mysql.columns_priv and mysql.procs_priv tables is changed to place the host name and user name columns together.
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
If you have a problem with indexes not being used when you believe that they should be, run ANALYZE TABLE to update table statistics, such as cardinality of keys, that can affect the choices the optimizer makes. The EXPLAIN statement provides ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
To use multiple-instance capability, modify the my.cnf option file to include configuration of key options for each instance. If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
VALUES row_constructor_list [ORDER BY column_designator] [LIMIT number] row_constructor_list: ROW(value_list)[, ROW(value_list)][, ...] value_list: value[, value][, ...] column_designator: column_index The VALUES statement consists of the VALUES ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens.html
The Version Tokens interface has these characteristics: Version tokens are pairs consisting of a name that serves as a key or identifier, plus a value. MySQL includes Version Tokens, a feature that enables creation of and synchronization around ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-crashing.html
This can normally be checked by pressing the Caps Lock key. If the Caps Lock light does not change, you have to replace your keyboard. (Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
A table that is used with a WHERE clause on a PRIMARY KEY or a UNIQUE index, where all index parts are compared to constant expressions and are defined as NOT NULL. All of the following tables are used as constant tables: SELECT * FROM t WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A MySQL server installed as a service can also be controlled from the command line using ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
mysqlx_ssl_key Command-Line Format --mysqlx-ssl-key=file_name System Variable mysqlx_ssl_key Scope Global Dynamic No SET_VAR Hint Applies No Type File name Default Value NULL The mysqlx_ssl_key system variable is like ssl_key, except that it applies ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #107991, Bug #34454572) Partitioning: When inserting NOW() into a column not part of the partition key of a partitioned table, all partitions were retrieved, and no pruning occurred. (Bug #37635908) Replication: In a source-replica setup, the ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...