Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
In this situation you can use MySQL Server's report_host system variable to configure a unique host name to be externalized by each of the servers. This section explains the configuration settings required for MySQL Server instances that you want ...Set the disabled_storage_engines system variable as follows to prevent their use: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Replication Framework The following settings configure replication according to the MySQL Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-server.html
The following discussion covers these MySQL server configuration topics: Startup options that the server supports. For listings of MySQL server variables and options that have been added, deprecated, or removed in MySQL 8.4, see Section 1.5, ...You ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server.html
Start the MySQL server like this if your installation includes mysqld_safe: $> bin/mysqld_safe --user=mysql & Note For Linux systems on which MySQL is installed using RPM packages, server startup and shutdown is managed using systemd rather than ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
You can use it from any program that can send SQL statements to the server to be executed, such as the mysql client program. Typically, database applications process large volumes of almost-identical statements, with only changes to literal or ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers. Attempting to add another server to a group with 9 members causes the request to join to be refused. Can I scale-out my write-load using Group ...How ...This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-api.html
NodeId: Number uniquely identifying SQL node or API node among all nodes in cluster. For a discussion of MySQL server options for NDB Cluster, see Section 25.4.3.9.1, “MySQL Server Options for NDB Cluster”. For information about MySQL server ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-rag.html
To define your natural-language query, set the @query variable: mysql> SET @query="AddYourQuery"; Replace AddYourQuery with your natural-language query. For example: mysql> SET @query="What is AutoML?"; To retrieve the augmented prompt, use the ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
See Section 10.3.1, “How MySQL Uses Indexes” and Section 10.8.1, “Optimizing Queries with EXPLAIN”. (When you reach a certain level of expertise, reading the EXPLAIN plan might be your first step for every query.) Adjust the size and ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
For example, mysqld_safe can handle server restarts, but systemd provides the same capability, and does so in a manner consistent with management of other services rather than by using an application-specific program. One implication of the non-use ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Logical backup methods have these characteristics: The backup is done by querying the MySQL server to obtain database structure and content information. Backups can be performed while the MySQL server is not running. Online Versus Offline Backups ...