Search Results
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
The time to acquire the initial locks is not counted as execution time. To specify the initial slow query log state explicitly, use --slow_query_log[={0|1}]. The slow query log consists of SQL statements that take more than long_query_time seconds ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server.html
Such problems can occur if you neglected to create the grant tables by initializing the data directory before proceeding to this step, or if you ran the command that initializes the data directory without the --user option. This section describes ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.4/en/user-names.html
Warning The MySQL user name length limit is hardcoded in MySQL servers and clients, and trying to circumvent it by modifying the definitions of the tables in the mysql database does not work. The MySQL installation process populates the grant tables ... MySQL stores accounts in the user table of the mysql system ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
This is true even if an account is locked initially because otherwise unlocking the account later would cause it to become accessible without a password that satisfies the policy. The validate_password component serves to improve security by ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The default compression levels are initially set to 3 for zstd, 2 for LZ4, and 3 for Deflate. The maximum compression levels are initially set to 11 for zstd, 8 for LZ4, and 5 for Deflate. X Plugin supports compression of messages sent over X ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
If the client is noninteractive, the initial value of the session variable is copied from the global mysqlx_wait_timeout variable. For interactive clients, the initial value is copied from the session mysqlx_interactive_timeout. To control ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
When XA PREPARE is issued, the first part of the transaction up to XA PREPARE is written using an initial GTID. Note that the initial part of the transaction, identified by XA_prepare_log_event, is not necessarily followed by its XA COMMIT or XA ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(WL #15924) InnoDB: Progress messages are now logged periodically during long-running rollbacks as informational note level error messages, initially as ER_IB_LONG_ROLLBACK_FULL (which appends transaction information) followed by successive ...(Bug ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
(Bug #36507020) Replication: Worker jobs now contain information about the relay log file which initiated the transaction, instead of using the default defined by relay_log. (Bug #36418426) Added the ER_LOG_PARTITION_PREFIX_KEY_NOT_SUPPORTED error ...It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or ...