PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...To ...| ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the difference. Memory summary tables do not contain timing information because memory events are not ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-performance-timers-table.html
For a cycle timer, the frequency is generally related to the CPU speed. TIMER_RESOLUTION Indicates the number of timer units by which timer values increase. If a timer has a resolution of 10, its value increases by 10 each time. TIMER_OVERHEAD The ...For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html
This occurs even if the new statement wait time is less than that of the current sample statement. The default value is calculated at server build time based on the number of commands in the client/server protocol and the number of SQL statement ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). 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. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html
COMPRESS_OPS The number of times a B-tree page of size PAGE_SIZE has been compressed. COMPRESS_OPS_OK The number of times a B-tree page of size PAGE_SIZE has been successfully compressed. COMPRESS_TIME The total time in seconds used for attempts to ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
You can use the following methods to speed up inserts: If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is considerably faster (many times ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/8.0/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
Of chief importance is the number of thread groups in the thread pool, which can be set on server startup using the --thread-pool-size option; this cannot be changed at runtime. The recommendation initial setting for this system variable is the ...