PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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-what-is-new-7-6.html
New features and other important changes in NDB Cluster 7.6 which are likely to be of interest are shown in the following list: New Disk Data table file format. A new file format is used in NDB 7.6 for NDB Disk Data tables, which makes it possible ...You can do this by performing an initial restart of each data node (that is, using the --initial option) as part of the upgrade ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
In some extreme cases, you can create the indexes even faster by turning them off with ALTER TABLE ... DISABLE KEYS before loading the file into the table and re-creating the indexes with ALTER TABLE ... INTO Statement”.) To write data from a ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
For example, you can enable an optimization for one table in a statement and disable the optimization for a different table. References to table and index names follow the usual identifier case sensitivity rules (see Section 9.2.3, “Identifier ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
You can use SET max_seeks_for_key=value as an alternative way to force MySQL to prefer key scans instead of table scans. [into_option] [FROM table_references [PARTITION partition_list]] [WHERE where_condition] [GROUP BY {col_name | expr | position} ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...They are permitted to make porting easier from other database ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. When the Performance Schema initializes, it populates the threads table based on the threads in existence then. The INSTRUMENTED and HISTORY column values for new threads are determined by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
(Bug #76734, Bug #20727344) You can upgrade such tables individually in the mysql client using the ALTER TABLE ... Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It ...mysql_upgrade communicates directly with the MySQL server, sending it the SQL statements required to perform an ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
A server restart also cancels the effect of the AUTO_INCREMENT = N table option in CREATE TABLE and ALTER TABLE statements, which you can use with InnoDB tables to set the initial counter value or alter the current counter value. InnoDB provides a ...The index is not required to be a PRIMARY KEY or UNIQUE, but to avoid duplicate values in the AUTO_INCREMENT column, those index types are ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. The discussion ...On Unix, make sure that they are readable by the user that mysqld runs as (and to you, because you need to access the files you are ...