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/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. See also the description of this option under table checking options. For a description of the output format, see Section 6.6.4.5, “Obtaining ...--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. Table 25.53 Common NDB cluster log messages Log Message Description Event Name Event Type Priority Severity Node mgm_node_id: Node data_node_id Connected The data node having node ...For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
Transaction Dependency and Writeset Handling Transaction dependencies are detected using analysis of each transaction's writeset, that is, the set of rows (table, key values) written by the transaction. Where a table has secondary unique keys, these ...To use this functionality with NDB Cluster, it is necessary that the following three conditions be met: Binary log transaction dependencies are determined at the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-pitr.html
Performing point-in-time recovery of NDB Cluster tables with NDB Cluster and NDB Cluster Replication can be accomplished using a native NDB data backup (taken by issuing CREATE BACKUP in the ndb_mgm client) and restoring the ndb_binlog_index table ... Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ... Events are processed in a ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
Executing internal-use BINLOG statements to apply mysqlbinlog output, provided that the account also has permission for the tables and operations in those statements. Updating the system tables mysql.gtid_executed, mysql.slave_relay_log_info, ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
The statement does not change the values of gtid_executed or gtid_purged, or the mysql.gtid_executed table. RESET REPLICA does not change any replication connection parameters, which include the source's host name and port, the replication user ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
To revoke all privileges from a user, use one of the following statements; either of these statements drops all global, database, table, column, and routine privileges for the named users or roles: REVOKE ALL PRIVILEGES, GRANT OPTION FROM ...[IGNORE ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Indexes are especially important for queries that reference ...