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/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ...Type The ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 23.4, “Using the Event ...
https://dev.mysql.com/doc/refman/5.7/en/perror.html
For most system errors, MySQL displays, in addition to an internal text message, the system error code in one of the following styles: message ... (Errcode: #) You can find out what the error code means by examining the documentation for your ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog ...Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-errors-or-warnings.html
These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these ...
https://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html
If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL server. To tell mysqld ...You can either tell mysqld not to open so many files at once or increase the number of file descriptors available to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. rpl_stop_slave_timeout: Number of seconds that STOP REPLICA or STOP SLAVE waits before timing out. slave_net_timeout: Number of seconds to ...enforce_gtid_consistency: Prevents execution of statements that cannot be logged in transactionally safe ... The following two sections provide basic ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
group_replication_components_stop_timeout Command-Line Format --group-replication-components-stop-timeout=# Introduced 5.7.17 System Variable group_replication_components_stop_timeout Scope Global Dynamic Yes Type Integer Default Value 31536000 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
This approach works well if the total number of writes to the group does not exceed the write capacity of any member in the group. Whenever the size of one of these queues exceeds the user-defined threshold, the throttling mechanism is triggered.
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
MAX_TIMER_WAIT The maximum wait time of the summarized timed wait events. Because waits are timed in picoseconds (trillionths of a second) by default, wait times are divided by 1000000000 to show wait times in milliseconds. A mutex is a ...The ...