PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-fractional-seconds.html
There may be problems replicating from a source server that understands fractional seconds to an older replica (MySQL 5.6.3 and earlier) that does not: For CREATE TABLE statements containing columns that have an fsp (fractional seconds precision) ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-triggers.html
A statement invoking a trigger (or function) that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based replication. With statement-based replication, triggers executed on the source also execute on the ...
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-sbr-rbr.html
This is because the BLOB column value is logged, rather than the statement generating the data. For most users, the mixed replication format should provide the best combination of data integrity and performance. If, however, you want to take ...
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/select-optimization.html
Set up indexes on columns used in the WHERE clause, to speed up evaluation, filtering, and the final retrieval of results. Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a ...