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/gis-class-multipoint.html
On a city map, a MultiPoint could represent the outlets for a ticket office. A MultiPoint is a geometry collection composed of Point elements. MultiPoint Examples On a world map, a MultiPoint could represent a chain of small islands. A MultiPoint ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-shutdown-restart.html
To restart the cluster on Unix platforms, run these commands: On the management host (198.51.100.10 in our example setup): $> ndb_mgmd -f /var/lib/mysql-cluster/config.ini On each of the data node hosts (198.51.100.30 and 198.51.100.40): $> ndbd Use ...On Windows platforms, assuming that you have installed the SQL node as a Windows service, you can use SC STOP service_name or NET STOP ... To shut down the cluster, enter the following command in a shell on the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-tcp-definition-direct.html
Setting up a cluster using direct connections between data nodes requires specifying explicitly the crossover IP addresses of the data nodes so connected in the [tcp] section of the cluster config.ini file. In the following example, we envision a ...The cluster as a whole resides on the 172.23.72.* subnet of a ...
https://dev.mysql.com/doc/refman/5.7/en/recovery-from-backups.html
The full backup file is just a set of SQL statements, so restoring it is very easy: $> mysql < backup_sunday_1_PM.sql At this point, the data is restored to its state as of Sunday 1 p.m.. | mysql For more information about using mysqlbinlog to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-blackhole.html
For this reason we recommend when you replicate to tables using the BLACKHOLE storage engine that you have the binlog_format server variable set to STATEMENT, and not to either ROW or MIXED. When performing binary logging, all inserts to such tables ... The BLACKHOLE storage engine accepts data but discards it and does not store ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-disable-background-threads.html
Produces a result set indicating how many background threads were disabled. Example mysql> CALL sys.ps_setup_disable_background_threads(); +--------------------------------+ | summary | +--------------------------------+ | Disabled 24 background ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-disable-consumer.html
Disables Performance Schema consumers with names that contain the argument. Parameters consumer VARCHAR(128): The value used to match consumer names, which are identified by using %consumer% as an operand for a LIKE pattern match. Example Disable ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-disable-instrument.html
Disables Performance Schema instruments with names that contain the argument. Parameters in_pattern VARCHAR(128): The value used to match instrument names, which are identified by using %in_pattern% as an operand for a LIKE pattern match. Example ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-disable-thread.html
Given a connection ID, disables Performance Schema instrumentation for the thread. This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Example Disable a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-enable-background-threads.html
Produces a result set indicating how many background threads were enabled. Example mysql> CALL sys.ps_setup_enable_background_threads(); +-------------------------------+ | summary | +-------------------------------+ | Enabled 24 background threads ...