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-mode-change-online-verify-transactions.html
There are several possible ways to wait for transactions to replicate: The simplest method, which works regardless of your topology but relies on timing is as follows: if you are sure that the replica never lags more than N seconds, just wait for a ... This section explains how to monitor a replication topology and verify that all anonymous transactions have been ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to corruption). It is also the fastest of the on-disk formats due to the ease with which rows in the data file can be found on disk: To look up a row ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/refman/5.7/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 ...
https://dev.mysql.com/doc/refman/5.7/en/uninstall-plugin.html
It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. The server executes the plugin's deinitialization function and removes the row for the plugin from the ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. For example, DO id FROM t1 is invalid because it references a table. DO is useful primarily with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-doublewrite-buffer.html
Because the doublewrite buffer setting is global, doublewrite buffering is also disabled for data files residing on non-Fusion-io hardware. The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before ...If ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering-names.html
To check which instrument or consumer names a pattern matches, perform a simple test: SELECT NAME FROM performance_schema.setup_instruments WHERE NAME LIKE 'pattern'; SELECT NAME FROM performance_schema.setup_consumers WHERE NAME LIKE 'pattern'; For ... Names given for filtering operations can be as specific or general as ...WHERE NAME LIKE 'wait/io/file/%'; The pattern '%/file/%' ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
For a server where binary logging is enabled (log_bin is ON), RESET MASTER deletes all existing binary log files and resets the binary log index file, resetting the server to its state before binary logging was started. For a server where GTIDs are ... RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
Configuring Stage Event Collection Stage Event Progress Information Configuring Stage Event Collection To control whether to collect stage events, set the state of the relevant instruments and consumers: The setup_instruments table contains ... The ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
To turn on all restrictions, you can simply use TRADITIONAL mode, which includes both strict mode values and ERROR_FOR_DIVISION_BY_ZERO: SET sql_mode='TRADITIONAL'; If a number is inserted into an exact type column (DECIMAL or integer), it is ...For ... With precision math, exact-value numbers are used as given whenever ...