Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
After the errors are fixed, perform a slow shutdown (by setting innodb_fast_shutdown=0) before attempting the upgrade again. A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and the InnoDB data dictionary can cause an ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading.html
Upgrading is a common procedure, as you pick up bug fixes within the same MySQL release series or significant features between major MySQL releases. This chapter describes the steps to upgrade a MySQL installation. You perform this procedure first ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
At one time, a scan was used based on whether the best index spanned more than 30% of the table, but a fixed percentage no longer determines the choice between using an index or a scan. This section discusses optimizations that can be made for ...
https://dev.mysql.com/doc/refman/8.4/en/which-version.html
Both tracks include bug fixes while innovation releases includes the latest new features and changes. The naming scheme in MySQL 8.4 uses release names that consist of three numbers and an optional suffix (for example, mysql-8.4.0). When preparing ...
https://dev.mysql.com/doc/refman/8.4/en/windows-server-first-start.html
If something is wrong with your configuration, these messages make it easier for you to identify and fix any problems. This section gives a general overview of starting the MySQL server. The following sections provide more specific information for ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
If given, it must be specified as a /ns suffix immediately following the address. An address with no /ns suffix uses the host system global namespace. An address with a /ns suffix uses the namespace named ns. mysqlx_bind_address is not dynamic, so ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-2.html
Bugs Fixed InnoDB: In some cases, following the creation of a very large number of tables (8001 or more), the server could not be restarted successfully. (Bug #36808732) References: This issue is a regression of: Bug #33398681. (Bug #110402, Bug ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.source.html
To fix a corruption problem in a replication source database, you can restore the backup, taking care not to propagate unnecessary SQL operations to the replica servers: Shut down the source database and then use, for example, the ...Edit the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-repository-options.html
You can optionally prefix the image name with file: to signify a file I/O (the default). Note that while you can specify a directory for saving the logs, the names of the log files are fixed and not reconfigurable by this option. These options ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for mysqlbackup. Here is a list of limitations of MySQL Enterprise Backup: In some cases, backups of non-transactional tables such as MyISAM tables could contain ...