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/replication-gtids.html
A general procedure for setting up and starting GTID-based replication (see Section 16.1.3.4, “Setting Up Replication Using GTIDs”). You can use either statement-based or row-based replication with GTIDs (see Section 16.2.1, “Replication ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser does not seem quite right. Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the ...
https://dev.mysql.com/doc/refman/5.7/en/source-installation-prerequisites.html
After Boost is installed, tell the build system where the Boost files are placed according to the value set for the WITH_BOOST option when you invoke CMake. To install MySQL from source, the following system requirements must be satisfied, ...Some ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. ST_GeoHash(longitude, latitude, max_length), ST_GeoHash(point, max_length) Returns a geohash string in the connection character set and ...Geohash values are strings that contain only characters chosen from ...
https://dev.mysql.com/doc/refman/5.7/en/stop-slave.html
You can control how long STOP SLAVE waits before timing out by setting the rpl_stop_slave_timeout system variable. ] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication threads. Recommended best practice is ...Like START SLAVE, this statement may be used with the IO_THREAD and SQL_THREAD options to name the thread or threads to be ...
https://dev.mysql.com/doc/refman/5.7/en/system-variables-controlling-tracing.html
optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET optimizer_trace_features=option=value[,option=value][,...] option: {greedy_search | range_optimizer | dynamic_range | ... The ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-installation.html
For general information about installing plugins, see Section 5.5.1, “Installing and Uninstalling Plugins”. If necessary, configure the plugin directory location by setting the value of plugin_dir at server startup. The file name suffix differs ... This section describes how to install MySQL Enterprise Thread ...
https://dev.mysql.com/doc/refman/5.7/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-ftdump.html
--dump, -d Command-Line Format --dump Dump the index, including data offsets and word weights. Before using myisam_ftdump, be sure to issue a FLUSH TABLES statement first if the server is running. If you do not invoke myisam_ftdump in the directory ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html
MySQL Enterprise Backup performs hot backup operations for MySQL databases. Hot backups are performed while the database is running and applications are reading and writing to it. For these reasons, hot backups are desirable when your database ...