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/constraint-invalid-data.html
By default, MySQL 8.0 rejects invalid or improper data values and aborts the statement in which they occur. Older versions of MySQL employed the forgiving behavior by default; for a description of this behavior, see Constraints on Invalid Data. It ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. In MySQL, a server-side cursor is materialized into an internal temporary table. A server-side cursor enables a result set to be generated on the server ...
https://dev.mysql.com/doc/refman/8.0/en/daemon-keyring-proxy-plugin.html
MySQL Keyring originally implemented keystore capabilities using server plugins, but began transitioning to use the component infrastructure in MySQL 8.0.24. The transition includes revising the underlying implementation of keyring plugins to use ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-limitations.html
This section describes temporary limitations introduced with the MySQL data dictionary. Manually created database directories are not recognized by the MySQL Server. Manual creation of database directories under the data directory (for example, ...
https://dev.mysql.com/doc/refman/8.0/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter-installation.html
For example, to prevent the plugin from being enabled at runtime, use this option: [mysqld] ddl-rewriter=OFF . To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir ... This section describes how to install or uninstall the ddl_rewriter ...
https://dev.mysql.com/doc/refman/8.0/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/8.0/en/drop-index.html
For more information, see Section 15.1.9, “ALTER TABLE Statement” MySQL NDB Cluster supports online operations using the same ALGORITHM=INPLACE syntax supported in the standard MySQL Server. algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | ...
https://dev.mysql.com/doc/refman/8.0/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/8.0/en/estimating-performance.html
In MySQL, an index block is usually 1,024 bytes and the data pointer is usually four bytes. As long as everything is cached by the OS or the MySQL server, things become only marginally slower as the table gets bigger. In most cases, you can ...