Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
Here, FOR SHARE is not a good solution because if two users read the counter at the same time, at least one of them ends up in deadlock when it attempts to update the counter. If you query data and then insert or update related data within the same ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
Too many active purge threads in this scenario can cause contention with user threads, so manage the innodb_purge_threads setting accordingly. The reason that a long running transaction can cause the History list length to increase is that under a ... InnoDB does not physically remove a row from the database immediately when you delete it with an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
For more information about the files and directories created by local checkpoints and global checkpoints, see NDB Cluster Data Node File System Directory. Because it is ubiquitous, most users employ TCP/IP over Ethernet for NDB Cluster. NDBCLUSTER ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
An attempt to create a partitioned tables using a storage engine that does not supply native partitioning support fails with ER_CHECK_NOT_IMPLEMENTED. Other sources of information about user-defined partitioning in MySQL include the following: MySQL ...Note Table partitioning differs from partitioning as used by window ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
For example, you might need to create a nonexistent table before you can start the replica again. This means that the replica can accept only that part of the database to which a given user has been granted access (as long as any updates to this ...
https://dev.mysql.com/doc/refman/8.4/en/server-loadable-functions.html
That terminology was something of a misnomer because “user-defined” also can apply to other types of functions, such as stored functions (a type of stored object written using SQL) and native functions added by modifying the server source code.
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
If you would like MySQL to start automatically, you can copy support-files/mysql.server to /etc/init.d and create a symbolic link to it named /etc/rc3.d/S99mysql.server. If you enable setuid() core files for the current user, they are generated ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-report-options.html
Users need to create their own plugin to define the variable. See The MySQL Plugin API for more information on user plugins. There are two options for controlling the progress reporting function of mysqlbackup: --show-progress and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-innodb.html
If you use the compressed backup feature, the .ibd files are renamed in their compressed form to .ibz files. The backed-up files, as they are originally copied, form a raw backup that requires further processing. The apply step (either as part of a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-upgrade.html
Users interested in the topic are advised to consult the MySQL server manual, especially the Upgrading MySQL and Downgrading MySQL sections, and pay careful attention to the requirements and restrictions discussed there. Install on the target server ... Important You may encounter technical challenges during a server upgrade or downgrade, and it is beyond the function of MySQL Enterprise Backup, as a backup tool, to ensure a successful server upgrade or ...