PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
In this case, because the default storage engine is InnoDB, the server does not start unless you also use --default-storage-engine and --default-tmp-storage-engine to set the default to some other engine for both permanent and TEMPORARY tables. This ... System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...This works for BLOB, MEDIUMBLOB, LONGBLOB, TEXT, MEDIUMTEXT, LONGTEXT, and JSON ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-operations.html
MySQL NDB Cluster 7.5 and 7.6 support online table schema changes using ALTER TABLE ... For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. The Version column in the output contains the table's schema object version. Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
Options that can be used with ndb_restore are shown in the following table. This may be desirable when backing up and restoring between different schema versions with primary key changes on one or more tables, and it appears that performing the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
However, because the efficiency of compression depends on the nature of your data, you can make decisions that affect the performance of compressed tables: Which tables to compress. If the system performs DML operations on compressed tables, and the ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...This is true as long as all data nodes are running and connected to the cluster; for a data node that is missing, there are no rows for the fragment replicas that it ...