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/mysql-cluster-config-example.html
You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings ... To support NDB Cluster, you must to update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
When XA COMMIT or XA ROLLBACK is issued, a second part of the transaction containing only the XA COMMIT or XA ROLLBACK statement is written using a second GTID. If there is an unexpected halt while the server is in the middle of executing an XA ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
Note To avoid potential performance issues, the number of chunks (innodb_buffer_pool_size / innodb_buffer_pool_chunk_size) should not exceed 1000. | +----------------------------------+----------------------------------+ Buffer pool resizing ... You ...
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
If you know that this is happening, you should try increasing net_read_timeout from its default of 30 seconds to 60 seconds or longer, sufficient for the data transfer to complete. In this case, if your connect_timeout value is set to only a few ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
It might work, but chances are that the operations race and then the act of joining the group ends up in an error or a time out. The use of other storage engines, including the temporary MEMORY storage engine, might cause errors in Group Replication. Set the disabled_storage_engines system variable as follows to prevent their use: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Note that with the MyISAM storage engine disabled, when you are upgrading a MySQL instance to a release where mysql_upgrade is still used (before MySQL 8.0.16), mysql_upgrade might fail with an ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
TIME_ZONE The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-check.html
This causes myisamchk to keep going, up through a maximum of 20 errors. To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. It first checks all index entries for errors and then reads through all ...What it cannot find is corruption that involves only the data file (which is very ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
YEAR(2) column definitions for new tables produce warnings or errors: Before MySQL 5.7.5, YEAR(2) column definitions for new tables are converted (with an ER_INVALID_YEAR_COLUMN_LENGTH warning) to 4-digit YEAR columns: mysql> CREATE TABLE t1 (y ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ...Type The ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 23.4, “Using the Event ...