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/show-create-table.html
When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
mysql> CREATE TABLE t1 (c1 INT) ENCRYPTION='Y'; To enable encryption for an existing file-per-table tablespace, specify the ENCRYPTION option in an ALTER TABLE statement. mysql> ALTER TABLE t1 ENCRYPTION='Y'; To disable encryption for file-per-table ...About Data-at-Rest Encryption Encryption Prerequisites Enabling File-Per-Table Tablespace Encryption Master Key Rotation Encryption and Recovery Exporting Encrypted Tablespaces Encryption and Replication Identifying Encrypted Tablespaces Encryption Usage Notes Encryption Limitations About Data-at-Rest Encryption InnoDB uses a two tier encryption key architecture, consisting of a master encryption key and tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
After the copies are created, mysql_cluster_move_privileges invokes mysql_cluster_move_grant_tables, which contains the ALTER TABLE ... Normally, each MySQL server's user privilege tables in the mysql database must use the MyISAM storage engine, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
Issue this ALTER TABLE statement to delete the current .ibd file: ALTER TABLE tbl_name DISCARD TABLESPACE; Copy the backup .ibd file to the proper database directory. Issue this ALTER TABLE statement to tell InnoDB to use the new .ibd file for the ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...MySQL Enterprise Backup The MySQL Enterprise Backup product lets you back up a ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
File Purpose tbl_name.frm Table format (definition) file tbl_name.MYD Data file tbl_name.MYI Index file Chapter 15, Alternative Storage Engines, describes what files each storage engine creates to represent tables. MySQL represents each table by an ...The relevant factors in the expression are: info_length is space needed for “screens.” This is related to MySQL's Unireg ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. This means that two different sessions can use the same temporary table ...While the procedure executes, the session uses the privileges of the defining ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_objects_size system variable at server ...The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. These properties make this compression technique unsuitable for use in an update-intensive database system. When compression is working well for a data ...The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. For example, in a UNION, scanned ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. If you run CHECKSUM TABLE against a view, the Checksum value is always NULL, and a warning is returned. For a nonexistent table, CHECKSUM TABLE returns NULL and ...You ...