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/faqs-tablespace-encryption.html
InnoDB data-at-rest encryption is designed to transparently apply encryption within the database without impacting existing applications. InnoDB data-at-rest encryption provides the benefit of encryption without the overhead associated with ...Is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
These properties make this compression technique unsuitable for use in an update-intensive database system. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB compression applies ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-blob-tool.html
If you need to specify a database, use the --database (-d) option. --database=db_name, -d Command-Line Format --database=name Type String Default Value [none] Specify the database to find the table in. This tool can be used to check for and remove ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? A.6.4. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ... (You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
Common index tables are retained even if full-text indexes are dropped. When a full-text index is dropped, the FTS_DOC_ID column that was created for the index is retained, as removing the FTS_DOC_ID column would require rebuilding the previously ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
It is not possible to drop partitions from NDB tables using ALTER TABLE ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Trying either to ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Foreign key constraints can make a TRUNCATE statement work like a regular DELETE statement, in which case a sequence of commands like DROP TABLE ...Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated indexes by creating the table without secondary indexes, then adding secondary indexes after the data is ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-hash-key.html
For a discussion of adding and dropping of partitions of tables that are partitioned by range or list, see Section 26.3.1, “Management of RANGE and LIST Partitions”. You cannot drop partitions from tables that are partitioned by HASH or KEY in ... Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html
For each statement that is taken from source, there is a code word stmt followed by a type (9 means DROP, 5 means INSERT, and so on). SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have ...