Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-updating-egress-endpoints.html
Updating Egress Endpoints for a Egress PrivateLink 6.3.4 Updating Egress Endpoints for a Egress PrivateLink You need to update the Egress Endpoints if the service in your account is listening on a different port, or you want to make it accessible ...Use the MySQL HeatWave Console to update the Egress Endpoints of a Egress ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-filter-definitions.html
An event in the connection class indicates when a connection-related activity occurs during a session, such as a user connecting to or disconnecting from the server. Important It is theoretically possible for a user with sufficient permissions to ...
https://dev.mysql.com/doc/refman/9.7/en/drop-role.html
When the read_only system variable is enabled, DROP ROLE additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). Roles named in the mandatory_roles system variable value cannot be dropped. Users who have the DROP ...
https://dev.mysql.com/doc/refman/9.7/en/hash-joins.html
It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system variable. Memory ...
https://dev.mysql.com/doc/refman/9.7/en/ibd2sdi.html
ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* files), and the data dictionary tablespace (mysql.ibd). ibd2sdi can be used at runtime or while the server ... ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-routines-table.html
CHARACTER_SET_CLIENT The session value of the character_set_client system variable when the routine was created. COLLATION_CONNECTION The session value of the collation_connection system variable when the routine was created. The ROUTINES table ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. Note If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the ...The MySQL column list is similar to what SQL Server 2000 returns for sp_statistics, except that QUALIFIER and OWNER are replaced with CATALOG and SCHEMA, ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-triggers-table.html
CHARACTER_SET_CLIENT The session value of the character_set_client system variable when the trigger was created. COLLATION_CONNECTION The session value of the collation_connection system variable when the trigger was created. To see information ...
https://dev.mysql.com/doc/refman/9.7/en/mrr-optimization.html
Two optimizer_switch system variable flags provide an interface to the use of MRR optimization. For MRR, a storage engine uses the value of the read_rnd_buffer_size system variable as a guideline for how much memory it can allocate for its buffer.
https://dev.mysql.com/doc/refman/9.7/en/optimizer-issues.html
MySQL uses a cost-based optimizer to determine the best way to resolve a query. In many cases, MySQL can calculate the best possible query plan, but sometimes MySQL does not have enough information about the data at hand and has to make ...