Search Results
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/telemetry-metrics-meter-metrics.html
The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno ...This includes only statements sent to the server by clients and not statements executed within stored ...binlog_stmt_cache_disk_use Binlog_stmt_cache_disk_use ASYNC COUNTER The number of nontransaction statements that used the binary log statement cache ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
However, this item inserts the SQL code directly into the SQL Query panel, where it can be edited further as required. Double-clicking a table, view, or column name in the schema explorer inserts the name into the SQL Query area. However, this item ... The Navigator area of the sidebar contains options to manage the active MySQL ...To access the Navigator ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-main-menu.html
When an SQL query tab is selected, the most important items on the main menu bar are the Query and Edit menus. SQL Query Menu The Query menu features the following items: Execute (All or Selection): Executes all statements in the SQL Query area, or ...Explain Current Statement: Describes the current statement by using the MySQL EXPLAIN ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
(For example, 100K means 100 × 1024 = 102400.) Parameter names and values are case-insensitive, unless used in a MySQL Server my.cnf or my.ini file, in which case they are case-sensitive. A management server that requests “any” node ID cannot ...For those parameters affecting memory usage or buffer sizes, it is possible to use K, M, or G as a suffix to indicate units of 1024, 1024×1024, or ...
https://dev.mysql.com/doc/refman/8.4/en/xa-statements.html
xid values are supplied by the client, or generated by the MySQL server. The gtrid and bqual values are interpreted in bytes by the MySQL server's underlying XA support routines. However, while an SQL statement containing an XA statement is being ...
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 ...
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/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/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 ...