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/replica-sql-thread-states.html
Waiting until MASTER_DELAY seconds after master executed event The SQL thread has read an event but is waiting for the replica delay to lapse. Making temporary file (create) before replaying LOAD DATA INFILE The thread is executing a LOAD DATA ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
Although an ALTER EVENT statement that contains another ALTER EVENT statement in its DO clause appears to succeed, when the server attempts to execute the resulting scheduled event, the execution fails with an error. When a user executes a ... ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. NON_UNIQUE 0 if the index ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-plugin-architecture.html
These interfaces isolate the MySQL Server core from the Group Replication plugin, and are mostly hooks placed in the transaction execution pipeline. The capture component is responsible for keeping track of context related to transactions that are ... MySQL Group Replication is a MySQL plugin and it builds on the existing MySQL replication infrastructure, taking advantage of features such as the binary log, row-based logging, and global transaction ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. --connect-retries Command-Line Format --connect-retries=# ...--core-file Command-Line Format --core-file Write core file on error; used in ...By default, it waits for the cluster to ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
To determine the default command option and system variable values used by the server, execute this command: $> mysqld --verbose --help The command produces a list of all mysqld options and configurable system variables. The following examples ...
https://dev.mysql.com/doc/refman/5.7/en/expressions.html
For the - operator, INTERVAL expr unit is permitted only on the right side, because it makes no sense to subtract a date or datetime value from an interval. For example, if you specify a unit of DAY_SECOND, the value of expr is expected to have ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. DATE_ADD() enables you to add a time interval to a given date. MySQL provides several functions that you can use to perform calculations on dates, for example, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
If an error occurs, the column value is the GTID of the transaction being executed by the worker when the error occurred. LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent worker error occurred. If gtid_mode ... If the replica is not multithreaded, this table shows the status of the applier ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine. ICP is not supported with secondary indexes created on virtual generated columns. The second ...