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/file-permissions.html
For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/file_name' (Errcode: 13) The default UMASK and UMASK_DIR values are 0640 and 0750, respectively. If you set its value, new ... If ...
https://dev.mysql.com/doc/refman/8.0/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...(To maximize performance, queries try to read as few data blocks as possible from disk; tables with only a few columns can fit more rows in each data ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-polygon.html
It is defined by a single exterior boundary and zero or more interior boundaries, where each interior boundary defines a hole in the Polygon. Polygon Examples On a region map, Polygon objects could represent forests, districts, and so on. Polygon ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-compatibility-communication.html
To check the group's communication protocol version, issue the following statement on any member: SELECT group_replication_get_communication_protocol(); The return value shows the oldest MySQL Server version that can join this group and use the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-fault-tolerance.html
As such, it requires a majority of servers to be active to reach quorum and thus make a decision. This has direct impact on the number of failures the system can tolerate without compromising itself and its overall functionality. As such if one ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-launching.html
Make sure the user is present in the server and that mysql_upgrade was ran after a server update. If you used plugin_load_add='group_replication.so' in the option file then the Group Replication plugin is already installed, and you can proceed to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-monitoring.html
These Performance Schema replication tables also show information relating to Group Replication: replication_connection_status shows information regarding Group Replication, such as transactions received from the group and queued in the applier ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-offline-upgrade.html
To perform an offline upgrade of a Group Replication group, you remove each member from the group, perform an upgrade of the member and then restart the group as usual. In a single-primary group, shutdown each secondary first and then finally the ...In a multi-primary group you can shutdown the members in any ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The minimum ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html
The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Note The ...If ...