Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%statement/%'; mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%stage/%'; Ensure that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
This section describes how to set up a MySQL server to use binary log file position based replication. Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in ...There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the source that you want to ...
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
Use SHOW ENGINE PERFORMANCE_SCHEMA STATUS to inspect the internal operation of the Performance Schema code: mysql> SHOW ENGINE PERFORMANCE_SCHEMA STATUS\G ... The number in the created column is the same as the number of data nodes in the cluster to ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
For information about the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics Area”. SIGNAL is typically used within stored programs, but it is a MySQL extension that it is permitted outside handler context. If SIGNAL refers to a ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). For example, put these lines in the server my.cnf file: [mysqld] ... The server-side ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-import-cluster.html
import cluster [--dryrun|-y] [--remove-angel] cluster_name This command imports a MySQL NDB Cluster created independently of MySQL Cluster Manager into a cluster named cluster_name that has been created in MySQL Cluster Manager. import cluster ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
In a cluster that is not running, the MySQL Cluster Manager merely updates the configuration files. However, in a running cluster, the MySQL Cluster Manager in addition automatically performs any node restarts or rolling restarts (see Performing a ...Attributes can be set on either the process level or instance ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...Executing a multiple-statement string can produce multiple result sets or row-count ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/introduction.html
This document describes what you need to know when working on the MySQL 8.4 code. To track or contribute to MySQL development, follow the instructions in Installing MySQL Using a Development Source Tree. If you are interested in MySQL internals, ...