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/repair-table.html
In the worst case, you might have a new clean index file without information about the data file, and then the next operation you perform could overwrite the data file. QUICK If you use the QUICK option, REPAIR TABLE tries to repair only the index ...Important Make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data ...Although normally ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log files. The default location for relay log files is the data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-transporters.html
Rows where the node_id is that of a data node which is not currently connected are not shown in this table. In NDB 8.0.37 and later, you can obtain similar information about individual transporters from the transporter_details table. This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
This does not apply to files and directories for specific products, such as the MySQL server data directory in %ProgramData% that is owned by SYSTEM. This includes defining custom file paths for the error log, general log, slow query log (including ...Note Full permissions are granted to the user executing MySQL Installer to all generated files, such as ...Unlike the initial ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-binlog.html
To restore data from the binary log, you must know the name and location of the current binary log files. By default, the server creates binary log files in the data directory, but a path name can be specified with the --log-bin option to place the ...The source of information for point-in-time recovery is the set of binary log files generated subsequent to the full backup ...Viewing log ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo.html
NDB Cluster also maintains tables in the INFORMATION_SCHEMA information database, including the FILES table which contains information about files used for NDB Cluster Disk Data storage, and the ndb_transid_mysql_connection_map table, which shows ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
The motivation for Disk-sweep MRR is to reduce the number of random disk accesses and instead achieve a more sequential scan of the base table data. The Multi-Range Read optimization provides these benefits: MRR enables data rows to be accessed ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html
To initiate replication, the binary logs required for the recipient to catch up to the donor must not be purged between the time that the data is cloned and the time that replication is started. Note that if the settings master_info_repository=FILE ...In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to the recipient, which enables using the clone plugin for provisioning Group Replication members and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html
If the aggregate size of connection attribute data sent by a client is larger than this amount, the Performance Schema truncates the attribute data, increments the Performance_schema_session_connect_attrs_lost status variable, and writes a message ...performance_schema_error_size Command-Line Format --performance-schema-error-size=# System Variable performance_schema_error_size Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value number of server error codes Minimum Value 0 Maximum Value 1048576 The number of instrumented server error ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-networking-issues.html
Applications using the cluster and user of those applications must not be permitted to have direct access to the management and data node hosts. It is extremely important to remember that NDB Cluster “out of the box” is not secure; you or your ... In this section, we discuss basic network security issues as they relate to NDB ...Also see Section 25.4.1, “Quick ...