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/mysql-cluster-programs-ndb-top.html
For measured load, blue is used for execution time, yellow for send time, red for time spent in send buffer full waits, and blank spaces for idle time. The display updates once per second; to set a different delay interval, use --sleep-time (-s).
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
Once this limit is exceeded, you must rename or remove the file before it is possible to execute any additional DDL statements. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
If the server does log the statement, the statement is sent to all replicas and each replica determines whether to execute it or ignore it. Instead, use filtering on the replica to control the events that are executed on the replica. On the replica ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgmd.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/information-schema-innodb-sys-tablestats-table.html
Statistics are collected again the next time the table is accessed. OTHER_INDEX_SIZE The number of pages on disk that store all secondary indexes for the table. This column is reset each time table statistics are recalculated AUTOINC The next number ... The INNODB_SYS_TABLESTATS table provides a view of low-level status information about InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
If you do not need the information provided by enabling lower-level settings, disable them and the Performance Schema executes less code on your behalf and you have less information to sift through. The consumer settings in the setup_consumers ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-file-by-latency.html
These views summarize global I/O consumers to display time waiting for I/O, grouped by file. total_latency The total wait time of timed I/O events for the file. read_latency The total wait time of timed read I/O events for the file. write_latency ...The io_global_by_file_by_latency and x$io_global_by_file_by_latency views have these columns: file The file path ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Configuration Options ps_thread_trx_info() operation ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-temptables.html
Temporary tables are replicated except in the case where you stop the replica server (not just the replication threads) and you have replicated temporary tables that are open for use in updates that have not yet been executed on the replica. The ...