PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
(The _RESET columns act like the lap counter on a stopwatch: you can measure the activity during some time interval, while the cumulative figures are still available in COUNT, MAX_COUNT, and so on.) MAX_COUNT_RESET The maximum counter value since it ... The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. The value is read from the external_language column of the mysql.routines data dictionary table. LAST_ALTERED The date and time when the routine was ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
Knowing how to take advantage of the buffer pool to keep frequently accessed data in memory is an important aspect of MySQL tuning. A table scan, performed for a mysqldump operation or a SELECT statement with no WHERE clause, for example, can bring ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-brokers.html
After configuring your server host to use a broker-supplied IPv6 address, start the MySQL server with an appropriate bind_address setting to permit the server to accept IPv6 connections. Note that if the broker allocates dynamic addresses, the ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-system-support.html
Before MySQL Server can accept IPv6 connections, the operating system on your server host must support IPv6. As a simple test to determine whether that is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 ...To produce a description of your system's network interfaces, invoke ifconfig -a and look for IPv6 addresses in the ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. Alternatively, ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The table is persistent so that column statistics need not be created each time the server starts. The value is one of int, uint (unsigned integer), double, decimal, datetime, or string (includes character and binary strings). On the other hand, the ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-transaction-management.html
For example, an application might encounter performance issues if it commits thousands of times per second, and different performance issues if it commits only every 2-3 hours. The default MySQL setting AUTOCOMMIT=1 can impose performance ... To ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-filtering.html
If you disable a consumer, the server does not spend time maintaining destinations for that consumer. If checked, they act as follows: events_statements_cpu, if NO, disables measurement of CPU_TIME. If YES, and the instrumentation is enabled and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
The following Performance Schema replication tables continue to be populated when the Performance Schema is disabled: replication_connection_configuration replication_connection_status replication_asynchronous_connection_failover ...This is similar ...