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-howto-masterstatus.html
row *************************** File: mysql-bin.000003 Position: 73 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) The File column shows the name of the log file ... 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-multi-source-reset-replica.html
To reset all currently configured replication channels: RESET SLAVE; To reset only a named channel, use a FOR CHANNEL channel clause: RESET SLAVE FOR CHANNEL "source_1"; For GTID-based replication, note that RESET SLAVE has no effect on the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-truncate-all-tables.html
Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
SQL statements can be executed using the mysql command-line client (connect as root to ensure that you have the necessary privileges). This section describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
As well as enabling you to configure connection parameters, MySQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL Editor. MySQL Workbench provides a graphical tool for working with MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-update.html
The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
If you really want rows sorted by the MySQL rule and secondarily by code point value, it is easy: ORDER BY s1 COLLATE utf32_unicode_ci, s1 COLLATE utf32_bin For supplementary characters based on UCA versions higher than 4.0.0 (for example, ... This ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
+----------------+----------+- The first row matches a connection by any user from h1.example.net, whereas the second row matches a connection by jeffrey from any host. When you attempt to connect to a MySQL server, the server accepts or rejects ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run stops. The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table.