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/server-logs.html
Log flushing occurs when you issue a FLUSH LOGS statement; execute mysqladmin with a flush-logs or refresh argument; or execute mysqldump with a --flush-logs option. You can control the general query and slow query logs during runtime. MySQL Server ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
It is not possible under normal circumstances in NDB Cluster to create an NDB Cluster table using any partitioning type other than [LINEAR] KEY, and attempting to do so fails with an error. The maximum number of partitions that can be defined for an ... The following limitations apply to the use of storage engines with user-defined partitioning of ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
If there is a difference between the tables, an error is returned and the statement fails. If you encounter an error message similar to ERROR 1017 (HY000): Can't find file: 'tbl_name.MRG' (errno: 2), it generally indicates that some of the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
If not specified, this argument defaults to its maximum value of 232 − 1. Option Value Meaning 1 Reject the document and produce an error. If an object has a CRS that is not understood, an error occurs, with the exception that if the optional srid ... This section describes functions for converting between GeoJSON documents and spatial ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. The importance of the binary log entries is ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
In conjunction with the MySQL binary log, you can perform point-in-time recovery. Start a second mysqld server on the backup and let it clean up the .ibd files in the backup. Restoring from a Logical Backup You can use a utility such as mysqldump to ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-management.html
The second method involves studying the contents of the cluster log ndb_node_id_cluster.log; this is usually found in the management server's DataDir directory, but this location can be overridden using the LogDestination option. More detailed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-multi-source.html
This does not automatically create binary logs on the second NDB Cluster's SQL node acting as the replica; in order to cause the binary logs to be created, you must issue a SHOW TABLES statement on that SQL node; this should be done prior to running ... It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
Examples: If you compare a DATETIME to two DATE values, convert the DATE values to DATETIME values. For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM ... Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
Connect again to the Oracle Key Vault server, this time without logging in. Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) enables ...