Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-creating-advisors-overview.html
You can change the Advisor name, change the Advisor category that an Advisor belongs to, set your own version number, and alter the threshold and frequency of an Advisor. This frame links variables used in the expression field with data gathered ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-settings-server-hostname-ref.html
Figure 15.1 Server Hostname Table 15.1 Server Hostname Controls Name Description Hostname Defines the hostname used in all notifications. Do not change this value from the default unless you have altered or redirected the default port number during ...Login Display Name Defines the hostname displayed on the login ...
https://dev.mysql.com/doc/heatwave-aws/en/hw-aws-upgrading-mysql-8.0-8.4.html
You can override the default authentication method of your user accounts with the CREATE USER and ALTER USER statements if needed. These new reserved words are added in MySQL 8.4: MANUAL, PARALLEL, QUALIFY, and TABLESAMPLE. Upgrade fails if you have ... Upgrading MySQL 8.0 BugFix to MySQL 8.4 LTS 3.1.2.2.1 Upgrading MySQL 8.0 BugFix to MySQL 8.4 LTS MySQL 8.4 LTS introduces some new features and removes some deprecated features as compared to MySQL 8.0 ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-connection.html
connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables ...Example ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. And you can likely scale-out a small fraction of your IO operations, since remote servers receive only ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-performance.html
If necessary, you can employ USE INDEX or FORCE INDEX to alter the execution plan. Unique hash indexes created with USING HASH cannot be used for accessing a table if NULL is given as part of the key. The following performance issues are specific ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-event.html
For example (using the same event e_daily defined and then altered in Section 15.7.7.19, “SHOW EVENTS Statement”): mysql> SHOW CREATE EVENT myschema.e_daily\G *************************** 1. SHOW CREATE EVENT event_name This statement displays ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-info.html
String format: Records: 3 Duplicates: 0 Warnings: 0 LOAD DATA String format: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 ALTER TABLE String format: Records: 3 Duplicates: 0 Warnings: 0 UPDATE String format: Rows matched: 40 Changed: 40 Warnings: 0 ... const char * mysql_info(MYSQL *mysql) Description Retrieves a string providing information about the most recently executed statement, but only for the statements listed ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-configuration-file-locations.html
You can alter the default locations at compile time by using the -DROUTER_CONFIGDIR=<path> option. The configuration is stored per router as JSON in the mysql_innodb_cluster_metadata.routers table with one row per router. MySQL Router scans for the ...