Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-filtering.html
The following principles apply: Destinations associated with a consumer receive no events unless the Performance Schema checks the consumer and the consumer is enabled. A consumer is checked only if all consumers it depends on (if any) are enabled.
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE ...
https://dev.mysql.com/doc/relnotes/mysql-shell/8.4/en/news-8-4-0.html
(WL #11816, WL #15955) The following, deprecated in previous releases, have been removed from AdminAPI: Commands: dba.configureLocalInstance() cluster.checkInstanceState() Options: ipWhitelist was removed from all commands which contained it. (Bug ...Deprecation and Removal Notes AdminAPI Added or Changed Functionality AdminAPI Bugs Fixed Utilities Added or Changed Functionality Utilities Bugs Fixed Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes The helper command, --dba=enableXProtocol, is deprecated and subject to removal in a future ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
If the table_encryption_privilege_check variable is enabled, the TABLE_ENCRYPTION_ADMIN privilege is required to use an ENCRYPTION clause with a setting that differs from the default schema encryption setting. When performing a copying ALTER TABLE, ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-dump-instance-schema.html
If the user account does not have the BACKUP_ADMIN privilege and LOCK INSTANCE FOR BACKUP cannot be executed, the utilities make an extra consistency check during the dump. If this check fails, an instance dump is stopped, but a schema dump or a ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-status-system-variables.html
The st_mysql_sys_var structure is defined as follows: struct st_mysql_sys_var { int flags; const char *name, *comment; int (*check)(THD*, struct st_mysql_sys_var *, void*, st_mysql_value*); void (*update)(THD*, struct st_mysql_sys_var *, void*, ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at view invocation time. The WITH CHECK OPTION clause can be given to constrain inserts or updates to rows in tables referenced by the view.
https://dev.mysql.com/doc/mysql-shell/9.4/en/upgrade-mysql-clusterset.html
Check the versions of the installed binaries: mysqlrouter --version: Checks the version of MySQL Router installed. Post Upgrade Status Check After upgrading MySQL Router, MySQL Shell, and MySQL Servers are upgraded: Check the status of the ... To ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-scanning-basic.html
This example illustrates how to use the NDB scanning API. It shows how to perform a scan, how to scan for an update, and how to scan for a delete, making use of the NdbScanFilter and NdbScanOperation classes. The source code for this example may ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utils-copy.html
If you defined a DB System as the target, the utility detects this and enables MySQL HeatWave Service compatibility checks by default. See Section 12.5, “Instance Dump Utility, Schema Dump Utility, and Table Dump Utility” for more information on ... This section describes the MySQL Shell copy utilities: About the Utilities Requirements and Restrictions Running the Utilities Options for Copy Control Options for Filtering Examples About the Utilities The copy utilities enable you to copy DDL and data between MySQL instances, without the need for intermediate ...