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-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. This means that ... A number of limitations exist in NDB Cluster with regard to the handling of ...To ensure that a given ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
Server plugins must be loaded into the server before they can be used. Installing Plugins Controlling Plugin Activation State Uninstalling Plugins Plugins and Loadable Functions Installing Plugins Before a server plugin can be used, it must be ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For example, you are using MyISAM tables on an operating system that supports files only up to ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
Additional Resources Resources related to backup or to maintaining data availability include the following: Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product for backups. This has several benefits, such as enabling ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
For InnoDB tables, both tables must use the same row format. To determine the row format of an InnoDB table, query INFORMATION_SCHEMA.INNODB_TABLES. Any partition-level MAX_ROWS setting for p must be the same as the table-level MAX_ROWS value set ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
The mecab_rc_file option is not recognized by MySQL until the MeCaB parser plugin is installed but it must be set before attempting to install the MeCaB parser plugin. [mysqld] innodb_ft_min_token_size=1 Modify the mecabrc configuration file to ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
Use the smallest integer data type for the AUTO_INCREMENT column that is large enough to hold the maximum sequence value you require. When the column reaches the upper limit of the data type, the next attempt to generate a sequence number fails. To ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...It also defines a secondary index k_d on column (d), but internally InnoDB extends this index and treats it as columns (d, i1, ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. NDB Cluster supports a join pushdown optimization whereby a qualifying join is sent in its entirety to NDB Cluster data nodes, where it can be distributed ...Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
Id Version (or later) NDB 8.0.13 Type or units unsigned Default [...] Range 1 - 255 Restart Type Initial System Restart: Requires a complete shutdown of the cluster, wiping and restoring the cluster file system from a backup, and then restarting the ... The [ndb_mgmd] section is used to configure the behavior of the management ...Although Id continues to be supported for backward compatibility, it ...