PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
Id Version (or later) NDB 8.0.13 Type or units unsigned Default [...] Range 1 - 255 Restart Type Initial System Restart: Requires a complete shutdown of the cluster, wiping and restoring the cluster file system from a backup, and then restarting the ... The [ndb_mgmd] section is used to configure the behavior of the management ...Although Id continues to be supported for backward compatibility, it ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
You want specific transactions in your workload to always read up-to-date data from the group, for example whenever sensitive data is updated (such as credentials for a file or similar data) and you want to enforce that reads retrieve the most up to ...This means that as soon as the incoming traffic slows down or stops, all group members have the same data ... In terms of distributed consistency guarantees, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-example.html
If used, the [ndbd default] section must precede any [ndbd] sections in the configuration file. The global configuration file must define the computers and nodes involved in the cluster and on which computers these nodes are located. For example, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-using-management-client.html
If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists. This function has the form shown here: key = KDF(random_salt, password) The key so generated is then used to encrypt the backup data using ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
The file must be located in the directory named by the plugin_dir system variable. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). To use a ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The tradeoffs are: An index must be updated when table data is modified. The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The ...The table ...This is needed when reading and parsing histograms from persistent storage into ...
https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html
However, it is possible to place InnoDB data and log files on different physical disks. You can also set the parameters for the file system that the database uses: If you do not need to know when files were last accessed (which is not really useful ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...For ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
If you run myisamchk somewhere other than in the database directory, you must specify the path to the database directory, because myisamchk has no idea where the database is located. In fact, myisamchk does not actually care whether the files you ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
temptable_max_ram: Defines the maximum amount of RAM that can be used by the TempTable storage engine before it starts allocating space from memory-mapped files or before MySQL starts using InnoDB on-disk internal temporary tables, depending on your ...Instead, it retains from temporary table creation only the data structures necessary to perform result column ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
It is very important to remember that, when you drop a partition, you also delete all the data that was stored in that partition. DROP PARTITION with ALGORITHM=INPLACE deletes data stored in the partition and drops the partition. However, DROP ...