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/performance-schema-events-waits-history-long-table.html
To set the table size explicitly, set the performance_schema_events_waits_history_long_size system variable at server startup. The Performance Schema autosizes the value of N during server startup. For more information about the relationship between ... The events_waits_history_long table contains N the most recent wait events that have ended globally, across all ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html
For DECIMAL columns, MySQL performs operations with a precision of 65 decimal digits, which should solve most common inaccuracy problems. The correct way to do floating-point number comparison is to first decide on an acceptable tolerance for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-load-data.html
When binlog_format=MIXED is set, the statement is logged in row-based format. When binlog_format=STATEMENT is set, note that LOAD DATA does not generate a warning, unlike other unsafe statements. LOAD DATA is considered unsafe for statement-based ...These temporary files are not automatically removed by mysqlbinlog or any other MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-interface.html
These settings help as the number of replicas increases, because contention for locks can slow down performance. There is one plugin for the source side and one for the replica side. To enable or disable the plugin, set this variable to 1 or 0, ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=dir_name Type Directory name The directory where character sets are installed. When the table is used later, the server reads into memory the information needed to decompress ...
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 ...