Search Results
https://dev.mysql.com/doc/refman/8.4/en/ipv6-local-connections.html
The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host address. Start the MySQL server with an appropriate bind_address setting to permit it to accept ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-remote-connections.html
The following procedure shows how to configure MySQL to permit IPv6 connections by remote clients. Start the MySQL server with an appropriate bind_address setting to permit it to accept IPv6 connections. For example, put the following lines in the ...It is similar to the preceding procedure for local clients, but the server and client hosts are distinct and each has its own nonlocal IPv6 ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
Note As of MySQL 8.4, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is deprecated. To reduce key cache access contention further, MySQL also provides multiple key caches. For example: mysql> ...Shared access to the key cache improves performance but does not eliminate contention among sessions ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. If loading data into a new MySQL instance, consider disabling redo logging ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a replica. The largest possible packet that can be transmitted to or ...Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-configurations.html
No Instrumentation Global Instrumentation Only Global and Thread Instrumentation Only Global, Thread, and Current-Event Instrumentation Global, Thread, Current-Event, and Event-History instrumentation No Instrumentation Server configuration state: ... The consumer settings in the setup_consumers table form a hierarchy from higher levels to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
For use with MySQL HeatWave Service and MySQL HeatWave, where the PRIMARY engine is InnoDB and the SECONDARY engine is MySQL HeatWave (RAPID). For MySQL Community Edition Server, MySQL Enterprise Edition Server (on-premise), and MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. mysql> SELECT PS_CURRENT_THREAD_ID(); +------------------------+ | ...The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The effect of the default object configuration is to instrument all objects except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. The setup_objects table controls whether the Performance Schema monitors particular table ...