PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-space-requirements.html
Each temporary sort file is large enough to hold one column of data, and each sort file is removed when its data is merged into the final table or index. Online DDL operations have the following space requirements: Temporary log files: A temporary ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-optimizer-statistics.html
You can view the last_update column of the mysql.innodb_table_stats and mysql.innodb_index_stats tables to see when statistics were last updated. This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
The auto-rehash feature enables automatic name completion of database, table, and column names for interactive users. Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. There are many reasons why you ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-truncate-table-reclaim-space.html
A foreign key constraint between two columns in the same table, however, is permitted. To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd ...
https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html
To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. The size ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. This type of locking is internal because it is performed entirely by the server and ...
https://dev.mysql.com/doc/refman/5.7/en/language-structure.html
This chapter discusses the rules for writing the following elements of SQL statements when using MySQL: Literal values such as strings and numbers Identifiers such as database, table, and column names Keywords and reserved words User-defined and ...
https://dev.mysql.com/doc/refman/5.7/en/load-index.html
To determine index block sizes for a table, use myisamchk -dv and check the Blocksize column. tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
The lock namespace, name, and mode appear in the OBJECT_SCHEMA, OBJECT_NAME, and LOCK_TYPE columns. MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map ...