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/innodb-online-ddl-performance.html
Note For a greater understanding of the MySQL processing associated with a DDL operation, examine Performance Schema and INFORMATION_SCHEMA tables related to InnoDB before and after DDL operations to see the number of physical reads, writes, memory ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
Instance dump utility util.dumpInstance(), schema dump utility util.dumpSchemas(), and table dump utility util.dumpTables() Export an instance, schema, or table to a set of dump files, which can then be uploaded to a MySQL instance using MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
The MySQL Performance Schema is a feature for monitoring MySQL server execution at a low level. The Performance Schema dynamically allocates memory incrementally, scaling its memory use to actual server load, instead of allocating required memory ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Under most circumstances, the default value should be sufficient, but when you have a great many NDB tables (1000 or more), it is possible to get Error 773 Out of string memory, please modify StringMemory config parameter: Permanent error: Schema ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-to-different-version.html
Since it is possible to restore metadata and table data separately, you can in such cases restore the table schemas from a dump made using mysqldump, or by executing the necessary CREATE TABLE statements manually, then import only the table data ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
To determine the row format of an InnoDB table, query the Information Schema INNODB_SYS_TABLES table. You can observe how this has happened by querying the Information Schema PARTITIONS table, as before. Table nt contains no foreign key references, ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | [SESSION | @@SESSION. | @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
The default is to make a snapshot of the current content of the Performance Schema events_statements_summary_by_digest table. The snapshot is stored in the sys schema tmp_digests temporary table. Otherwise, it must be the name of an existing view ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a database. These ...
https://dev.mysql.com/doc/refman/5.7/en/create-database.html
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... Rules for permissible database names are given in Section 9.2, “Schema Object Names”. create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name ...