Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-communication-protocol.html
For example: SELECT group_replication_set_communication_protocol("8.0.16"); The group_replication_set_communication_protocol() function is implemented as a group action, so it is executed at the same time on all members of the group. If a member ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-schema.html
For example, to view information about instrumented InnoDB file objects seen by the Performance Schema when executing file I/O instrumentation, you might issue the following query: mysql> SELECT * FROM performance_schema.file_instances WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-brokers.html
For example: userid=gogouser passwd=gogopass Start gogoc: $> /etc/init.d/gogoc start To start gogoc each time your system boots, execute this command: $> rc-update add gogoc default Use ping6 to try to ping a host: $> ping6 ipv6.google.com To see ...
https://dev.mysql.com/doc/refman/8.4/en/midpoint-insertion.html
If the block stays at the beginning of the sublist for a long enough time, it is demoted to the warm sublist. This time is determined by the value of the key_cache_age_threshold component of the key cache. The midpoint insertion strategy helps to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
You can also obtain this list by executing TABLE ndbinfo.dict_obj_types in the mysql client. Secondary ordered indexes are fragmented and distributed in the same way as the base table. In the memory_per_fragment table, we can see that ordered ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
This is a “cold start” procedure that assumes either that you are starting the source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source server, see Section ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/setting-environment-variables.html
For csh and tcsh, use setenv to make the shell variable available to the environment: setenv MYSQL_TCP_PORT 3306 The commands to set environment variables can be executed at your command prompt to take effect immediately, but the settings persist ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
A user variable referenced by a statement in a stored procedure has its type determined the first time the procedure is invoked, and retains this type each time the procedure is invoked thereafter. A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.4/en/thread-information.html
To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. row *************************** Id: 5 User: ...
https://dev.mysql.com/doc/refman/8.4/en/windows-create-option-file.html
For options that are used every time the server starts, you may find it most convenient to use an option file to specify your MySQL configuration. Note When using MySQL Configurator to configure MySQL Server, it creates the my.ini at the default ...