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/information-schema-partitions-table.html
PARTITION_COMMENT The text of the comment, if the partition has one. Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger belongs. TRIGGER_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
Dumped tables are stored into text files that are human-readable, so spotting table corruption becomes easier. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
The storage layout for table data is more efficient for BLOB and long text fields, with the DYNAMIC row format. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
This setting may still be useful for tables with many long BLOB, VARCHAR or TEXT columns, because such values often do compress well, and might therefore require fewer overflow pages as described in Section 14.9.1.5, “How Compression Works for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
LONGBLOB and LONGTEXT columns must be less than 4GB, and the total row length, including BLOB and TEXT columns, must be less than 4GB. The data files that you define in the configuration file using the innodb_data_file_path configuration option ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-developing.html
The data stored through the daemon_memcached plugin goes into VARCHAR, TEXT, or BLOB columns, and must be converted to do numeric operations. Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
Standard memcached protocols, including the text-based protocol and the binary protocol. The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL layer. The ...