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/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/connecting-disconnecting.html
For help with other problems often encountered when trying to log in, see Section B.3.2, “Common Errors When Using MySQL Programs”. To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
You can also query the tables in the ndbinfo information database for real-time data about many NDB Cluster operations. This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. It is always enabled and attempting to disable it (--skip-secure-auth, --secure-auth=0) produces an ... The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-build-configuration.html
One indication of this issue is the presence of messages such as the following in the error log: [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure [ERROR] Native table ...It is possible to exclude certain parts ...
https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. With this plugin-loading method, the option must be given each time the server starts. For example: mysql> SELECT PLUGIN_NAME, ...This ...
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 ...