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/innodb-online-ddl-failure-conditions.html
The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary online log exceeds the value of the innodb_online_alter_log_max_size configuration option. The changes made by the concurrent DML take ...A ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
In strict mode, these statements fail, and some or all the values are not inserted or changed, depending on whether the table is a transactional table and other factors. If no restrictive modes are enabled, MySQL clips the value to the appropriate ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. Its value is constructed from the User and Host columns of the user table row for the account. However, this value does not necessarily ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
In NDB 8.0.31 and later, you can enable binary logging of compressed transactions for tables using the NDB storage engine at run time using the ndb_log_transaction_compression system variable introduced in that release, and control the level of ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error. This is in contrast to all other data types, for which storage is allocated once per column when the table is opened. A BLOB is a binary large object that ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. On the other hand, requesting the public key from the server is more convenient (it requires no management of a client-side file) and may be acceptable in secure network ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
The table shown at https://msdn.microsoft.com/en-us/goglobal/cc305152.aspx provides information about the Unicode values of cp932 characters. For cp932 table entries with characters under which a four-digit number appears, the number represents the ... Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 ...
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles component loading and unloading, and also registers loaded components in the mysql.component ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-optimizer.html
The server maintains histogram statistics about column values in the column_statistics data dictionary table (see Section 10.9.6, “Optimizer Statistics”). Like other data dictionary tables, this table is not directly accessible by users. MySQL ...