Search Results
https://dev.mysql.com/doc/refman/8.4/en/locking-issues.html
MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple threads. This type of locking is internal because it is performed entirely ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
You should keep the following issues and notes in mind: Other MySQL installations: The installation procedure does not recognize MySQL installations by package managers such as Homebrew. The installation and upgrade process is for MySQL packages ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-pkg.html
The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. Note Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the ...
https://dev.mysql.com/doc/refman/8.4/en/making-trace-files.html
If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. To do this, you must have a mysqld that has been compiled with debugging support. If the version number ends with -debug, it is ...
https://dev.mysql.com/doc/refman/8.4/en/monitoring-performance-schema.html
You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.
https://dev.mysql.com/doc/refman/8.4/en/multibyte-characters.html
If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character functions in the ctype-MYSET.c source file in the strings directory. The existing character sets provide the best ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
This may lead to unpleasant surprises if your operating system does not support fault-free system locking. Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a data directory for a new ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
Note As of MySQL 8.4, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is deprecated. Shared access to the key cache improves performance but does not eliminate contention among sessions ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-unix-servers.html
Note The discussion here uses mysqld_safe to launch multiple instances of MySQL. For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
This section describes how to check for and deal with data corruption in MySQL databases. If your tables become corrupted frequently, you should try to find the reason why. For an explanation of how MyISAM tables can become corrupted, see Section ...