Search Results
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
In the few cases that ANALYZE TABLE does not produce values good enough for your particular tables, you can use FORCE INDEX with your queries to force the use of a particular index, or set the max_seeks_for_key system variable to ensure that MySQL ...MySQL also supports setting the histogram of a single column to a user-defined JSON ...ANALYZE ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-security.html
For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. By default, contents of audit log files produced by the audit log plugin are not ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
Suppose that a query searches the SCHEMATA.SCHEMA_NAME column for the test database. A lower_case_table_names setting of 1 or 2 causes the second query to return the same (nonempty) result as the first query. Note It is prohibited to start the ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
A menagerie distribution containing some of the queries and sample data used in the following sections can be obtained from the MySQL website. Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-interfaces.html
To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document based applications. You can use MySQL Shell to prototype applications, execute queries ...Installing MySQL Shell has instructions to download and install MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
An example of such a query, using the table t1 created previously, is shown here: mysql> EXPLAIN -> SELECT * FROM t1 AS x -> LEFT JOIN t1 AS y -> ON x.a=0 AND y.b>=3\G *************************** 1. To disable it at server startup, set the ... This ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; To check that the plugin was ...
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
The GTID sets used with this function are represented as strings, as shown in the following examples: mysql> SELECT GTID_SUBSET('3E11FA47-71CA-11E1-9E33-C80AA9429562:23', -> '3E11FA47-71CA-11E1-9E33-C80AA9429562:21-57')\G *************************** ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-temp-table-info.html
Create a simple InnoDB temporary table: mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; Query INNODB_TEMP_TABLE_INFO to view the temporary table metadata. row *************************** TABLE_ID: 194 NAME: #sql7a79_1_0 N_COLS: ...mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%'; +---------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_TEMP%) | +---------------------------------------------+ | INNODB_TEMP_TABLE_INFO | +---------------------------------------------+ For the table definition, see Section 28.4.27, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO ...
https://dev.mysql.com/doc/refman/8.4/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...