PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html
See Section 16.1.2.5.3, “Setting Up Replication between a New Source and Replicas” for how to proceed. Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for InnoDB tables. The source's binary log coordinates ... To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads.html
You can enable further parallelization for tasks on a replica by setting the slave_parallel_workers system variable to a value greater than 0 (the default). Note Multithreaded replicas are not currently supported by NDB Cluster, which silently ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the variables. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions.html
MySQL implements two sets of functions using function names defined by the OpenGIS specification. One set tests the relationship between two geometry values using precise object shapes, the other set uses object minimum bounding rectangles (MBRs).
https://dev.mysql.com/doc/refman/5.7/en/which-version.html
For example, distributions normally are compiled with support for all character sets. If you want a smaller MySQL server, you can recompile it with support for only the character sets you need. When preparing to install MySQL, decide which version ...First, decide whether to install a development release or a General Availability (GA) ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily defined and then altered in Section 13.7.5.18, “SHOW EVENTS Statement”): mysql> SHOW CREATE EVENT myschema.e_daily\G ... SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disks. You can move databases or tables from the database directory to other ...To determine the location of your data directory, use this statement: SHOW VARIABLES LIKE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
SELECT * FROM INFORMATION_SCHEMA.ENGINES [WHERE ENGINE LIKE 'NDB%'] This is the equivalent of SHOW ENGINES, but uses the ENGINES table of the INFORMATION_SCHEMA database. You can also query the tables in the ndbinfo information database for ... This ...SHOW ENGINES This statement can be used to determine whether or not clustering support is enabled in the MySQL server, and if so, whether it is ...