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/import-table.html
IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege for the table to be created. If the .sdi file is placed in that directory, however, it may be rewritten; the import operation creates a new ...The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata ...For example, the .sdi file can be placed in the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
If you now execute a SHOW CREATE TABLE statement, you can see how the partitioning makeup of the table has been changed: mysql> SHOW CREATE TABLE tr\G *************************** 1. Another solution might appear to be to make a copy of the table ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
When you create a MERGE table, MySQL creates a .MRG file on disk that contains the names of the underlying MyISAM tables that should be used as one. Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ...In earlier MySQL versions, metadata was stored in metadata files, nontransactional tables, and storage engine-specific dictionaries, which necessitated intermediate ...An ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_DEFAULT_STOPWORD: Holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
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 required schema changes to this copy. ALGORITHM=INPLACE can be used to perform online ADD ... MySQL NDB Cluster 8.0 supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. To override these system-wide settings and configure optimizer statistics parameters for ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description of your table. If you start the MySQL server with external locking ...The output from these commands is explained later in this ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ALTER TABLE statements are also visible in ndb_desc output. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
Tables assigned to the system tablespace using CREATE TABLE or ALTER TABLE TABLESPACE=innodb_system have a SPACE_TYPE of General. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”.