PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
Once a data file has been created, its size cannot be changed; however, you can add more data files to the tablespace using additional ALTER TABLESPACE ... In addition, any data file to be dropped must previously have been added to the tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The storage engine creates other files, all having names beginning with the table name. Attempting to create an index on any other column results in ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
You can also create a binary backup simply by copying all table files, as long as the server is not updating anything. Also, even if the server is not actively updating data, InnoDB may still have modified data cached in memory and not flushed to ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). This type of backup is suitable for smaller amounts of data where you ...
https://dev.mysql.com/doc/refman/5.7/en/cache-index.html
The key cache referred to in a CACHE INDEX statement can be created by setting its size with a parameter setting statement or in the server parameter settings. A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE ...| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
With FOR UPGRADE, the server checks each table to determine whether there have been any incompatible changes in any of the table's data types or indexes since the table was created. If your table was created by a different version of the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
The session time zone that is current when a CREATE EVENT or ALTER EVENT statement executes is used to interpret times specified in the event definition. Other times available from these sources indicate when an event was created or last altered; ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
How are triggers managed in MySQL? Triggers can be created using the CREATE TRIGGER statement, and dropped using DROP TRIGGER. See Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”, for more about ...