PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Setting the SQL Mode The Most Important SQL Modes Full List of SQL Modes Combination SQL Modes Strict SQL Mode Comparison of the IGNORE Keyword and Strict SQL Mode For answers to questions often asked about server SQL modes in MySQL, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
As a development technique to guard against a runaway recursive CTE, you can force termination by placing a limit on execution time: The cte_max_recursion_depth system variable enforces a limit on the number of recursion levels for CTEs. The path ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
Termination of filtering includes any current sessions for those users: They are detached from the filter and no longer logged. Value Description ALL Log all connection events ERRORS Log only failed connection events NONE Do not log connection ...
https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html
This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database server. For information about optimizing an InnoDB configuration to improve I/O performance, see Section 10.5.8, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-midpoint_insertion.html
For an explanation of the inner workings of the InnoDB buffer pool and specifics about the LRU algorithm, see Section 17.5.1, “Buffer Pool”. Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
Consider the following MySQL proxy account definition: CREATE USER ''@'%' IDENTIFIED WITH authentication_ldap_sasl AS '+ou=People,dc=example,dc=com#grp1=usera,grp2,grp3=userc'; The authentication string has a user DN suffix ... Note LDAP pluggable ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-binary.html
This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by Oracle. For setting up a cluster using precompiled binaries, the first step in the installation process ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-config-params.html
The config_params table is a static table which provides the names and internal ID numbers of and other information about NDB Cluster configuration parameters. This table can also be used in conjunction with the config_values table for obtaining ...