Search Results
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
To display the current structure of the log tables, use these statements: SHOW CREATE TABLE mysql.general_log; SHOW CREATE TABLE mysql.slow_log; Log contents are accessible through SQL statements. A mysqldump dump includes statements to recreate ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
ALGORITHM=INPLACE, REORGANIZE PARTITION statement in the mysql client for each NDBCLUSTER table. Exception: For tables created using the MAX_ROWS option, this statement does not work; instead, use ALTER TABLE ... You can do this by issuing, for each ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-security-procedures.html
Be sure to run the FLUSH PRIVILEGES statement as soon as you have modified the mysql.user table, so that the changes take immediate effect. In this section, we discuss MySQL standard security procedures as they apply to running NDB Cluster. In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-upgrade-downgrade.html
Some of the reasons for this are listed here: DDL statements on NDB tables are not possible during some phases of data node startup. DDL statements on NDB tables may be rejected if any data nodes are stopped during execution; stopping each data node ... Versions Supported for Upgrade to NDB 8.4 Known Issues When Upgrading or Downgrading NDB Cluster This section provides information about NDB Cluster software and compatibility between different NDB Cluster releases with regard to performing upgrades and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise-thread-pool.html
The default thread-handling model in MySQL Server executes statements using one thread per client connection. As more clients connect to the server and execute statements, overall performance degrades. The plugin implements a thread pool that ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
It is created by the server upon execution of SET PERSIST or SET PERSIST_ONLY statements. The rules for escape sequences in option files differ slightly from the rules for escape sequences in string literals in SQL statements. For example, the ...
https://dev.mysql.com/doc/refman/8.4/en/parenthesized-query-expressions.html
parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
In the sections that follow, we do not necessarily provide all possible forms for the syntax that can be used for creating each partition type; for this information, see Section 15.1.20, “CREATE TABLE Statement”. This section discusses the ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
On Unix, the mysql client writes a record of executed statements to a history file (see Section 6.5.1.3, “mysql Client Logging”). Passwords can be written as plain text in SQL statements such as CREATE USER and ALTER USER, so if you use these ...