Search Results
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 8.4, through release 8.4.8. It also does not teach you how to use your operating system or command-line interpreter. Typographical and Syntax Conventions This manual uses certain ...Differences between minor versions of MySQL 8.4 are noted in the present text with reference to release numbers ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
In addition, if the explicit_defaults_for_timestamp system variable is disabled, you can initialize or update any TIMESTAMP (but not DATETIME) column to the current date and time by assigning it a NULL value, unless it has been defined with the NULL ... TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
The eq_range_index_dive_limit system variable enables you to configure the number of values at which the optimizer switches from one row estimation strategy to the other. Prior to MySQL 8.4, there is no way of skipping the use of index dives to ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. The server SQL mode is controlled as described in ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
To set the table size explicitly, set the performance_schema_accounts_size system variable at server startup. The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-users-table.html
To set the table size explicitly, set the performance_schema_users_size system variable at server startup. The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-temptables.html
In statement-based replication mode, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside a transaction, procedure, function, or trigger when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
The Rewriter plugin exposes system variables that enable plugin configuration and status variables that provide runtime operational information. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by ...