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/partitioning.html
An attempt to create a partitioned tables using a storage engine that does not supply native partitioning support fails with ER_CHECK_NOT_IMPLEMENTED. Note Table partitioning differs from partitioning as used by window functions. MySQL 8.0 does not ...In MySQL 8.0, partitioning support is provided by the InnoDB and NDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-quick.html
Try to create an NDBCLUSTER table: $> mysql mysql> USE test; Database changed mysql> CREATE TABLE ctest (i INT) ENGINE=NDBCLUSTER; Query OK, 0 rows affected (0.09 sec) mysql> SHOW CREATE TABLE ctest \G *************************** 1. You can now ...
https://dev.mysql.com/doc/refman/8.0/en/function-loading.html
Installing Loadable Functions Uninstalling Loadable Functions Reinstalling or Upgrading Loadable Functions Installing Loadable Functions To load a loadable function manually, use the CREATE FUNCTION statement. For example: CREATE FUNCTION metaphon ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. By default, a single system tablespace data file, named ibdata1, is created in the data directory. The only ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
Multiple replication filtering rules can be created in a single CHANGE REPLICATION FILTER statement by separating the rules with commas, as shown here: CHANGE REPLICATION FILTER REPLICATE_DO_DB = (d1), REPLICATE_IGNORE_DB = (d2); Issuing the ...
https://dev.mysql.com/doc/refman/8.0/en/lock-instance-for-backup.html
LOCK INSTANCE FOR BACKUP permits DDL operations that only affect user-created temporary tables. In effect, files that belong to user-created temporary tables can be created, renamed, or removed while a backup lock is held. LOCK INSTANCE FOR BACKUP ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while preventing operations that could result in an inconsistent ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. Table 25.53 Common NDB cluster log messages Log Message Description Event Name Event Type Priority Severity Node mgm_node_id: Node data_node_id Connected The data node having node ...For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
(GRANT does not create such rows when lower_case_table_names is set, but such rows might have been created prior to setting the variable. To revoke all privileges from a user, use one of the following statements; either of these statements drops all ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
An attempt to create partitioned tables in MySQL 8.0 using any other storage engine fails. The disabled_storage_engines configuration option defines which storage engines cannot be used to create tables or tablespaces. partition is also no longer ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The example uses the test.city table described in Creating a New Table and Column Mapping. The examples use the test.city table described in Creating a New Table and Column Mapping. For example, the table switch in this example is valid: get ... The ...