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/numeric-type-syntax.html
(There is also a limit on how long the text of DECIMAL literals can be; see Section 12.21.3, “Expression Handling”.) UNSIGNED, if specified, disallows negative values. For integer data types, M indicates the minimum display width. Display width ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. Rather than testing for equality against a very long text string, you can store a hash of the column value in a separate column, index that column, and test the ...Do ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column FTS_DOC_ID at table creation time, of type BIGINT UNSIGNED NOT NULL, with a unique index named FTS_DOC_ID_INDEX. Note When adding ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
For MyISAM tables that change frequently, try to avoid all variable-length columns (VARCHAR, BLOB, and TEXT). Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns.html
The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
If you have deleted a large number of rows from a partition or if you have made many changes to a partitioned table with variable-length rows (that is, having VARCHAR, BLOB, or TEXT columns), you can use ALTER TABLE ... A number of table and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
Note As of MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is removed in MySQL 8.0, when the storage engine used for a given table is expected to provide its own (“native”) partitioning handler. Use of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
The Executed_Gtid_Set field can show a large set with a great deal of text. This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html
performance_schema_max_sql_text_length Command-Line Format --performance-schema-max-sql-text-length=# System Variable performance_schema_max_sql_text_length Scope Global Dynamic No Type Integer Default Value 1024 Minimum Value 0 Maximum Value ...The ...