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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-fractional-seconds.html
MySQL 8.0 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-index-statistics.html
select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed inserts into the index. update_latency The total wait time of timed updates in the index. delete_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-avg-latency.html
total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the class.
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-latency.html
total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the class.