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/information-schema-tablespaces-table.html
Other INFORMATION_SCHEMA tables may provide related information: For NDB, the INFORMATION_SCHEMA FILES table provides tablespace-related information. For InnoDB, the INFORMATION_SCHEMA INNODB_SYS_TABLESPACES and INNODB_SYS_DATAFILES tables provide ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup-recovery.html
For information about backup techniques applicable to InnoDB, see Section 14.19.1, “InnoDB Backup”. For information about point-in-time recovery, recovery from disk failure or corruption, and how InnoDB performs crash recovery, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression.html
This section provides information about the InnoDB table compression and InnoDB page compression features. Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. The benefits are amplified for ...The page compression feature is referred to as transparent page ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-defragmenting.html
Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> 12345; The preceding query requires MySQL to perform a full table scan, the slowest type ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-identifying.html
If you enable a different file format using the innodb_file_format configuration option, the change only applies to newly created tables. Also, when you create a new table, the tablespace containing the table is tagged with the “earliest” or ...
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
The following table shows the required storage and range for each integer type. MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, ...
https://dev.mysql.com/doc/refman/5.7/en/leave.html
If the label is for the outermost stored program block, LEAVE exits the program. LEAVE label This statement is used to exit the flow control construct that has the given label.
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-options.html
To specify an option file for a C program, use the --defaults-file option as one of the elements of the second argument of the mysql_library_init() function. Any options that may be given with the mysqld server daemon, may be used with an embedded ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-apt-repo.html
The MySQL APT repository provides deb packages for installing and managing the MySQL server, client, and other components on the current Debian and Ubuntu releases. Instructions for using the MySQL APT Repository are available in A Quick Guide to ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-sles-repo.html
The MySQL SLES repository provides RPM packages for installing and managing the MySQL server, client, and other components on SUSE Enterprise Linux Server. Instructions for using the MySQL SLES repository are available in A Quick Guide to Using the ...