Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
This operation does not perform an implicit UNLOCK TABLES, so an error results if you perform the operation while there is any active LOCK TABLES or use it a second time without first releasing the locks acquired. | tables_option } flush_option: { ...| table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
set commands are executed whether or not the cluster has been started. However, since restart operations—particularly rolling restarts—can take a great deal of time, it is preferable to make configuration changes before starting the cluster and ...Attributes can be set on either the process level or instance ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-tableconfiguration-category.html
Flush Time How often (in seconds) to close all tables, to free up resources and synchronize unflushed data to disk, for low resource systems. Max Tmp Tables The maximum number of temporary tables a client can keep open at the same time. Explicit ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
If the inferred data type is incompatible with the table definition, Lakehouse Auto Parallel Load raises an error, and specifies the column as NOT SECONDARY. mysql> GRANT PROCESS ON database_name.* TO 'user_name'@'%'; The EXECUTE privilege on the ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
If you are using replication, you should specify an expiration period that is no lower than the maximum amount of time your replicas might lag behind the source. When using MySQL with logging enabled, you may want to back up and remove old log files ... As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
In this case, you should remove all redo log files, start your MySQL 8.3 server on the same data directory, and fix the cause of any errors. Note The upgrade process does not upgrade the contents of the time zone tables. For upgrade instructions, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-performance-timers-table.html
For a cycle timer, the frequency is generally related to the CPU speed. TIMER_RESOLUTION Indicates the number of timer units by which timer values increase. If a timer has a resolution of 10, its value increases by 10 each time. TIMER_OVERHEAD The ...For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
Load Data Using Auto Parallel Load First, run Auto Parallel Load in dryrun mode to check for errors and warnings and to inspect the generated load script. If Auto Parallel Load fails with an error, inspect the errors with a query to the ... You can ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
Attempting to run innochecksum on a tablespace that the server already has open results in an Unable to lock file error. Example usage: innochecksum --version --verbose, -v Command-Line Format --verbose Type Boolean Default Value false Verbose mode; ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...