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-options-binary-log.html
binlog_max_flush_queue_time Command-Line Format --binlog-max-flush-queue-time=# Deprecated Yes System Variable binlog_max_flush_queue_time Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 100000 Unit microseconds ...binlog_group_commit_sync_delay Command-Line Format --binlog-group-commit-sync-delay=# System Variable binlog_group_commit_sync_delay Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 1000000 Unit microseconds Controls how many microseconds the binary log commit waits before synchronizing the binary log file to ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. For MAX_USER_CONNECTIONS, the limit is an integer representing the maximum number of simultaneous connections by the account. For example, to remove ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
Configuring Transaction Event Collection Transaction Boundaries Transaction Instrumentation Transactions and Nested Events Transactions and Stored Programs Transactions and Savepoints Transactions and Errors Configuring Transaction Event Collection ...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/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/replication-administration-skip.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. First you need to identify the replicated event that caused the error. Details of the error and the last successfully applied transaction are ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-count.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The index value of the empty string error value is 0. Value Index NULL NULL '' 0 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
If cas_column and expire_time_column fields of the innodb_memcached.containers table are set to NULL, the following error is returned when attempting to load the memcached plugin: InnoDB_Memcached: column 6 in the entry for config table 'containers' ...If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-event-buffer.html
BUFFERED_EPOCHS_OVER_THRESHOLD: Whether the number of buffered epochs has exceeded the configured threshold. The report is generated every second until the number of buffered epochs goes below the threshold, which can be adjusted by setting the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
For multithreaded replica operation, SHOW SLAVE STATUS reports all coordinator and worker thread errors using the Last_SQL_Errno and Last_SQL_Error fields, so only the most recent of those errors is visible and information can be lost. The ...This ...