PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
This can result in huge improvements by reducing the amount of data written to and read from disk. If you access a table mostly by searching on a combination of columns, create a single composite index on them rather than a separate index for each ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-language.html
This applies to messages the server writes to the error log and sends to clients. To select the language in which the server writes error messages, follow the instructions in this section. The server searches for the error message file using these ... By default, mysqld produces error messages in English, but they can be displayed instead in any of several other languages: Czech, Danish, Dutch, Estonian, French, German, Greek, Hungarian, Italian, Japanese, Korean, Norwegian, Norwegian-ny, Polish, Portuguese, Romanian, Russian, Slovak, Spanish, or ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object body. In this case, the account “adopts” the object and, with the appropriate privileges, is able to execute it ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
This is true even for strings that are preceded by an introducer that indicates a different character set, as discussed in Section 10.3.6, “Character String Literal Character Set and Collation”. The \% and \_ sequences are used to search for ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. Example server-side error messages written to the error log: This message produced during the startup process provides a status or progress indicator: ...Error Message Sources Error Message Elements Error Message Sources Error messages can originate on the server side or the client side: On the server side, error messages may occur during the startup and shutdown processes, as a result of issues that occur during SQL statement execution, and so ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. It is also possible to use 0 for OFF, and 1 for ON when setting this variable. For this reason, ON and OFF are usually ...When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the output of SHOW PROCESSLIST, as shown in the discussion that ...