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/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...Although the internal range of values for YEAR/YEAR(4) and the deprecated YEAR(2) type is the same (1901 to 2155, and 0000), the display width for YEAR(2) makes that type inherently ambiguous because displayed values indicate only the last two digits of the internal values and omit the century ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
The numeric values specified for this option correspond to isolation levels such as REPEATABLE READ. This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
This issue can occur if MySQL is configured to read from or write to a non-default directory or file. In this case, a “denial” message is logged to /var/log/audit/audit.log: $> grep "denied" /var/log/audit/audit.log type=AVC ... Troubleshooting ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A consequence of this is that SET member values should not themselves contain commas. For more information on this limit, see Limits Imposed by .frm File Structure. For example, you can retrieve numeric values from a SET column like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
See MySQL Cluster Manager 1.4.8 User Manual, for more information about this tool. When I run the SHOW command in the NDB Cluster management client, I see a line of output that looks like this: A.10.8. The loading process terminates prematurely and ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
Some basic information about XPath syntax and usage is provided later in this section; however, an in-depth discussion of these topics is beyond the scope of this manual, and you should refer to the XML Path Language (XPath) 1.0 standard for ...Note ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD ...
https://dev.mysql.com/doc/refman/5.7/en/channels-startup-options.html
This section describes startup options which are impacted by the addition of replication channels. If this variable is set to FILE, attempting to add more sources to a replica fails with ER_SLAVE_NEW_CHANNEL_WRONG_REPOSITORY. If this variable is ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...The ...
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs frequently. If the error message includes “during query,” this is probably the case you are experiencing. If you know that ...Sometimes the “during query” form happens when millions of rows are being sent as part of one or more ...