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/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 ...
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/myisam-start.html
Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers between writes for any MyISAM table. Note If you do this, you should not access MyISAM tables from another program (such as from another MySQL server or with myisamchk) ...
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.