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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
$> mysqld --innodb-buffer-pool-size=8G --innodb-buffer-pool-instances=16 mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024; +------------------------------------------+ | @@innodb_buffer_pool_size/1024/1024/1024 | ... You can configure InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
* * In your $HOME/.my.cnf file, you probably want to put: [test2_libmysqld_SERVER] language = /path/to/source/of/mysql/sql/share/english * You could, of course, modify argc and argv before passing * them to this function. * * If you link this client ... These two example programs should work without any changes on a Linux or FreeBSD ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
See Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”, for information on how to change this. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-multiple-nodes.html
A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this lock. This is true for a lock issued by any statement that locks tables as part of its operations.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The Performance Schema must be enabled or this table is empty. This information enables the server to avoid caching bad or missing host names during temporary DNS failures, which would negatively affect clients forever. For the rationale why this ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
An instrument disabled in this table produces no events regardless of the contents of the other production-related setup tables. An instrument enabled in this table is permitted to produce events, subject to the contents of the other tables. This ...