PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. Note: Undoing the above should be as simple as deleting the registry entries you've created. A MySQL client on Unix can connect to ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. The debug_options value is a sequence of colon-separated fields: field_1:field_2:...:field_N Each field within the value consists of a ...
https://dev.mysql.com/doc/refman/8.0/en/drop-logfile-group.html
(For information on creating log file groups, see Section 15.1.16, “CREATE LOGFILE GROUP Statement”.) Important Before dropping a log file group, you must drop all tablespaces that use that log file group for UNDO logging. DROP LOGFILE GROUP ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
It removes privilege rows for the account from all grant tables. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system schema. DROP USER does not automatically drop or invalidate databases or ...The DROP USER statement removes one or more MySQL accounts and their ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
Be aware that a remote cloning operation removes user-created tablespaces and data from the joining member before transferring the data from the donor. Cloning is therefore not suitable for groups where members run different minor MySQL Server ...If ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-failure-detection.html
In a replication group, each member has a point-to-point communication channel to each other member, creating a fully connected graph. If a member does not receive messages from another member for 5 seconds, it suspects that the member has failed, ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
Table 14.26 GTID Functions Name Description Deprecated GTID_SUBSET() Return true if all GTIDs in subset are also in set; otherwise false. The functions described in this section are used with GTID-based replication. It is important to keep in mind ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
For other ways to reduce or tune I/O for table operations, see Section 10.5.8, “Optimizing InnoDB Disk I/O”. Increase the setting when processing large numbers of updates intended only for statistical analysis, where losing the last N updates in ... Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be somewhat slower than using memcached by ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-restructuring.html
For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's ... A key cache can be restructured at any time by updating its parameter ...