PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics.html
total_latency The total wait time of timed I/O events for the table. fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table. update_latency The total wait ...By default, rows are sorted by descending total wait time (tables with most contention ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
The following discussion describes the structure of the diagnostics area in MySQL, the information items recognized by MySQL, how statements clear and set the diagnostics area, and how diagnostics areas are pushed to and popped from the stack. If a ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
You can prevent the use of other storage engines by setting the disabled_storage_engines system variable on group members, for example: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Primary Keys. A setting of 1 is correct for ... Server instances that you want to use for Group Replication must satisfy the following ...If there are ...
https://dev.mysql.com/doc/refman/5.7/en/show-relaylog-events.html
Note Some events relating to the setting of user and system variables are not included in the output from SHOW RELAYLOG EVENTS. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL ...The LIMIT clause has the same syntax as for the SELECT ...If ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
This can be done by setting an appropriate value in the config.ini file for the MaxNoOfExecutionThreads configuration parameter or the ThreadConfig configuration parameter. ndbmtd is intended for use on host computers having multiple CPU cores. For ... ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. Regardless of the statement ...You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new ...
https://dev.mysql.com/doc/refman/5.7/en/mysql.html
If you have problems due to insufficient memory for large result sets, use the --quick option. This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) and the local query handler (LQH), and written to the cluster log. Because some transactions committed in ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
BackupDiskWriteSpeedPct: Sets percentage of data node's allocated maximum write speed (MaxDiskWriteSpeed) to reserve for LCPs when starting backup. DefaultHashMapSize: Set size (in buckets) to use for table hash maps. HeartbeatOrder: Sets order in ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...