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-mode-change-online-verify-transactions.html
A safer method in the sense that it does not depend on timing: if you only have a source with one or more replicas, do the following: On the source, execute: SHOW MASTER STATUS; Note down the values in the File and Position column. This section ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
Use SHOW PROCESSLIST, find the I/O and SQL threads and check their State column to see what they display. If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages.
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
The value in the Time column can show how late the replica is compared to the source. The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding replication. For information on ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
To revoke all privileges, use the second syntax, which drops all global, database, table, column, and routine privileges for the named user or users: REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... The REVOKE statement enables system ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
The plugin communicates with users by setting the message column of table rows. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions ...
https://dev.mysql.com/doc/refman/5.7/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns. Partitioning is not supported for tables using the CSV storage engine.
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. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variable-reference.html
The last column indicates whether the scope for each variable is Global, Session, or both. The following table lists all status variables applicable within mysqld. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/5.7/en/show-character-set.html
SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if present, indicates which character set names to match. The WHERE clause can be given to select ...
https://dev.mysql.com/doc/refman/5.7/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...