Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version-major.html
This function returns the major version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_major(); +-----------+---------------------+ | VERSION() | sys.version_major() | +-----------+---------------------+ | 8.4.2 | 8 | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version-minor.html
This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +-----------+---------------------+ | VERSION() | sys.version_minor() | +-----------+---------------------+ | 8.4.2 | 4 | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version-patch.html
This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +-----------+---------------------+ | VERSION() | sys.version_patch() | +-----------+---------------------+ | 8.4.2 | 2 | ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...
https://dev.mysql.com/doc/refman/8.4/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36301441) Audit log filtering by type, using error as the type, did not work correctly. (Bug #36142157) Following an unplanned shutdown and restart, the file that was in use by the server for writing at the time may be broken or otherwise ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-report-options.html
There are two options for controlling the progress reporting function of mysqlbackup: --show-progress and --progress-interval: --show-progress[={stderr|stdout|file:FILENAME|fifo:FIFONAME|table|variable}] Command-Line Format ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-binary-log-data-structures.html
C API functions for processing a replication event stream from a server require a connection handler (a MYSQL * pointer) and a pointer to a MYSQL_RPL structure that describes the steam of replication events to read from the server binary log. int ...