PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/events-configuration.html
Alternatively, you can use ON (or 1) or OFF (or 0) in place of the DISABLED value when starting the server. Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
The innodb_api_enable_mdl option can be used to lock the table at the MySQL level, so that the mapped table cannot be dropped or altered by DDL through the SQL interface. Direct access to InnoDB tables, bypassing the SQL parser, the optimizer, and ... The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL ...
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 ...