PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. File-per-table tablespace characteristics are described under the following topics in this section: ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-purge-configuration.html
InnoDB does not physically remove a row from the database immediately when you delete it with an SQL statement. A row and its index records are only physically removed when InnoDB discards the undo log record written for the deletion. This removal ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the NDBCLUSTER storage engine. ndbmtd is intended for use on host computers having multiple CPU cores. Command-line options and configuration ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable Optimizations”). Changes to this variable affect execution of all subsequent queries; to affect one query differently ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
MySQL 5.7 provides a number of ways to modify partitioned tables. It is possible to add, drop, redefine, merge, or split existing partitions. All of these actions can be carried out using the partitioning extensions to the ALTER TABLE statement.
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines only. Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata repository. If binary log file position based replication is in use, when the replica restarts, it reads the two ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 5.1.7, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...