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/assigning-passwords.html
MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. If the redo log files occupy less space than the specified value, dirty pages are flushed from the buffer pool to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-exclusive-to-cluster.html
NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a binary log for tables having BLOB columns but no primary key. The following are limitations specific to the NDB storage engine: ...
https://dev.mysql.com/doc/refman/8.0/en/view-syntax.html
To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, “DROP VIEW Statement”). The CREATE VIEW statement creates a new view (see Section 15.1.23, ...
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 ...