https://dev.mysql.com/create-table.html
AUTO_INCREMENT An integer or floating-point column can have the additional attribute AUTO_INCREMENT. If a table has a PRIMARY KEY or UNIQUE NOT NULL index that consists of a single column that has an integer type, you can use _rowid to refer to the ... CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_options] [partition_options] CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [partition_options] [IGNORE | REPLACE] [AS] query_expression CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name { LIKE old_tbl_name | (LIKE old_tbl_name) } create_definition: col_name column_definition | {INDEX|KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/mysql-cluster-ndbinfo-tc-time-track-stats.html
scan_errors integer Based on duration of failed scans from opening to closing, tracked against the API or data nodes requesting them. transaction_errors integer Based on duration of failing transactions from start to point of failure, tracked ...
https://dev.mysql.com/audit-log-file-formats.html
The following statement displays the possible names: SELECT REPLACE(EVENT_NAME, 'statement/sql/', '') AS name FROM performance_schema.events_statements_summary_global_by_event_name WHERE EVENT_NAME LIKE 'statement/sql/%' ORDER BY name; ... The MySQL ...
https://dev.mysql.com/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/mysql-cluster-ndbinfo-threadstat.html
The threadstat table provides a rough snapshot of statistics for threads running in the NDB kernel. The following table provides information about the columns in the threadstat table. For each column, the table shows the name, data type, and a ...
https://dev.mysql.com/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/mysql-cluster-ndbinfo-memory-per-fragment.html
The memory_per_fragment table provides information about the usage of memory by individual fragments. The following table provides information about the columns in the memory_per_fragment table. For each column, the table shows the name, data type, ...
https://dev.mysql.com/x-plugin-options-system-variables.html
mysqlx_connect_timeout Property Value Command-Line Format --mysqlx-connect-timeout=# System Variable mysqlx_connect_timeout Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 30 Minimum Value 1 Maximum Value 1000000000 The ... To control activation of X Plugin, use this option: --mysqlx[=value] Property Value Command-Line Format --mysqlx[=value] Introduced 8.0.11 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/replication-options-master.html
For each server, you should pick a unique positive integer in the range from 1 to 232 − 1, and each ID must be different from every other ID in use by any other replication master or slave. Both variables have global and session values, and each ... This section describes the server options and system variables that you can use on replication master ...
https://dev.mysql.com/mysql-cluster-ndbinfo-server-operations.html
The server_operations table contains entries for all ongoing NDB operations that the current SQL node (MySQL Server) is currently involved in. It effectively is a subset of the cluster_operations table, in which operations for other SQL and API ...
