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/check-table.html
CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM Tables CHECK TABLE Output CHECK TABLE returns a result set with the columns shown in the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
The exception is that for Unicode, the utf8 character set can be used, but not the ucs2 character set. Full-text searches are supported for InnoDB and MyISAM tables only. Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN ...Ideographic languages such as Chinese and Japanese do not have word ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 4MB. More information on setting the packet size is ...The most common reason for the MySQL server has gone away error is that the server timed out and closed the ...
https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html
Prerequisites for Installing from Development Source Setting Up a MySQL Git Repository Prerequisites for Installing from Development Source To install MySQL from a development source tree, your system must satisfy the tool requirements listed at ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
The chief difference between the two types of partitioning is that, in list partitioning, each partition is defined and selected based on the membership of a column value in one of a set of value lists, rather than in one of a set of contiguous ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
Normally, if any expression in a string comparison is case-sensitive, the comparison is performed in case-sensitive fashion. For more information about that option, see Section 4.5.1, “mysql — The MySQL Command-Line Client”. For example, it ...
https://dev.mysql.com/doc/refman/5.7/en/using-gdb-on-mysqld.html
In this case, you should set the following environment variable in the shell before starting gdb: LD_ASSUME_KERNEL=2.4.1 export LD_ASSUME_KERNEL When running mysqld under gdb, you should disable the stack trace with --skip-stack-trace to be able to ... On most systems you can also start mysqld from gdb to get more information if mysqld ...With some older gdb ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_SCHEMA The name of the schema (database) containing the unique constraint that the constraint references. The possible values are CASCADE, SET ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? A.1.5. Which version of MySQL is production-ready (GA)? MySQL 9.4, 8.4, and 8.0 are actively supported for production use. MySQL 8.0 achieved General Availability (GA) ...Does MySQL have a NOW() function with fractions of seconds? ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) ...A ...Eliminating unnecessary transaction IDs reduces the size of internal data structures that are consulted each time a query or data change statement constructs a read ...