Search Results
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
The order of evaluation for expressions involving user variables is undefined. HAVING, GROUP BY, and ORDER BY, when referring to a variable that is assigned a value in the select expression list do not work as expected because the expression is ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
If the transaction is not empty, the replica is able to continue running, but you should take steps to discontinue the use of replication filters with XA transactions in order to avoid potential issues. If two XA transactions committed in parallel ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
InnoDB: The log index size calculation now accounts for column order changes. For a SELECT with ORDER BY and LIMIT, the optimizer first chose a full table scan with a very expensive cost, then performed another check and used the perform_order_index ...It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
(Bug #37021075) Performance; Replication: The data structure used in tracking binary log transaction dependencies has been changed from Tree to ankerl::unordered_dense::map, which uses approximately 60% less space, and which should thus contribute ... C API Notes Compilation Notes Configuration Notes SQL Function and Operator Notes JavaScript Programs Performance Schema Notes sys Schema Notes Thread Pool Notes Functionality Added or Changed Bugs Fixed C API Notes The asynchronous interface used unsafe static local variables to store state ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource issues. Only on platforms supporting posix_fadvise(): ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
In order to that, after making first a full backup that contains all data, you can do one of the following: Performing a series of differential backups. Each differential backups includes all the changes made to the data since the last full backup ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-autotune.html
autotune [--dryrun] [--sequential-restart] [--writeload=writeload] template cluster_name writeload: {low|medium|high} template: {web|realtime|test} The command autotune a number of parameters for the cluster according to the specified values for ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-eventual-consistency.html
Order of delivery for any sequence of messages is always identical for all agents (that is, messages cannot get out of order for some agents). MySQL Cluster Manager guarantees eventual consistency among agents, meaning that: Any message ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-tarball.html
When the agent is configured as a daemon, cluster processes are started automatically when the agent is restarted, as long as the cluster was running when the agent shut down; however, StopOnError must be disabled (set to 0) for all data nodes in ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-next-result.html
The values will appear in the order in which they are declared in the procedure parameter list. Return Values Return Value Description 0 Successful and there are more results -1 Successful and there are no more results >0 An error occurred Errors ...