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-programs-ndb-redo-log-reader.html
Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or both. Command-Line Format -nocheck -nocheck: Do not check the log file for errors. ndb_redo_log_reader is intended for use primarily by NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster itself. SHOW ENGINE NDB STATUS, SHOW ENGINE ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Column Value Table The table name Op Always optimize Msg_type status, error, info, note, or warning Msg_text An informational message OPTIMIZE TABLE table catches and throws any errors that occur while copying table statistics from the old file to ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/8.0/en/option-modifiers.html
If applied to a system variable that has only a global value, an error occurs. For example, with --maximum-back_log=200, the server produces this error: Maximum value of 'back_log' cannot be set . Some options are “boolean” and control behavior ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
For information about how MySQL handles character sets and collations, see Chapter 12, Character Sets, Collations, Unicode. Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Important For a key-partitioned table, you cannot execute an ALTER TABLE DROP PRIMARY KEY, as doing so generates the error ERROR 1466 (HY000): Field in list of fields for partition function not found in table. Partitioning by key is similar to ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
Example: ALTER TABLE t1 REPAIR PARTITION p0,p1; Normally, REPAIR PARTITION fails when the partition contains duplicate key errors. You can check partitions for errors in much the same way that you can use CHECK TABLE with nonpartitioned tables. A ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-build-configuration.html
One indication of this issue is the presence of messages such as the following in the error log: [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure [ERROR] Native table ...It is possible to exclude certain parts ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...