PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
MySQL and Virus Checking Software Virus-scanning software such as Norton/Symantec Anti-Virus on directories containing MySQL data and temporary tables can cause issues, both in terms of the performance of MySQL and the virus-scanning software ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-resources.html
The resources table contains the following columns: node_id The unique node ID of this data node. max The maximum amount (number of 32KB pages) of this resource that is available to this data node. DISK_OPERATIONS: If a log file group is allocated, ... This table provides information about data node resource availability and ...This is approximately 2 MB per ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
Options on the command line take precedence over values specified in option files and environment variables, and values in option files take precedence over values in environment variables. In many cases, it is preferable to use an option file ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-quick.html
First, you need to create a configuration directory such as /var/lib/mysql-cluster, by executing the following command as the system root user: $> mkdir /var/lib/mysql-cluster In this directory, create a file named config.ini that contains the ...# ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. You can choose a setting that suits the workload of your group and your priorities for data reads and writes, taking into account the ...Any member that is compatible with the other group members is set to read/write mode when joining the group, and can process write transactions, even if they are issued ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
For example, if you do not care about performance data for file I/O, you can start the server with all Performance Schema parameters related to file I/O set to 0. The mutex still functions as a synchronization object (that is, the server continues ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
If validate_password rejects the new password, it reports an error indicating the minimum number of characters that must differ. If the file is named as a relative path, it is interpreted relative to the server data directory. For the dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
(That is, the statement fails if creating an account would cause the account to adopt a currently orphaned stored object.) To perform the operation anyway, you must have the SET_USER_ID privilege; in this case, the statement succeeds with a warning ...To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system ...It enables authentication, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
ndb-connectstring=management_host[:port] In the event that you are not using NDB Cluster on the replica, you can create a backup with this command on the source: shellS> mysqldump --master-data=1 Then import the resulting data dump onto the replica ...To provide replication backup capability, you also need to add an --ndb-connectstring option to the replica's my.cnf file prior to starting the replication ... Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/8.0/en/internal-locking.html
Deadlocks affect performance rather than representing a serious error, because InnoDB automatically detects deadlock conditions by default and rolls back one of the affected transactions. The tradeoff is that this strategy reduces concurrency; other ...For locking performed on MySQL files by other programs, see Section 10.11.5, “External ... This section discusses internal locking; that is, locking ...