Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-nodes.html
The config_generation column shows which version of the cluster configuration is in effect on each data node. The nodes table contains the following columns: node_id The data node's unique node ID in the cluster. config_generation The version of the ... This table contains information on the status of data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The type column shows the schema object type used for this fragment, which can take any one of the values System table, User table, Unique hash index, or Ordered index. The table_id column value is unique at any given time, but can be reused if the ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
--columns=column_list, -c column_list Command-Line Format --columns=column_list This option takes a list of comma-separated column names as its value. The order of the column names indicates how to match data file columns with table columns. The ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-blob.html
For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table and referencing it with a join query when needed. See Section 10.4.2.2, ... When ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
In InnoDB, having a long PRIMARY KEY (either a single column with a lengthy value, or several columns that form a long composite value) wastes a lot of disk space. (See Section 17.6.2.1, “Clustered and Secondary Indexes”.) Create an ... Once ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
Each connection table has CURRENT_CONNECTIONS and TOTAL_CONNECTIONS columns to track the current and total number of connections per “tracking value” on which its statistics are based. The accounts table has USER and HOST columns to track ...
https://dev.mysql.com/doc/refman/8.4/en/sorting-rows.html
This means that the order is undefined for columns that are identical except for their case. You can force a case-sensitive sort for a column by using BINARY like so: ORDER BY BINARY col_name. You may have noticed in the preceding examples that the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
There must be no views with explicitly defined columns names that exceed 64 characters (views with column names up to 255 characters were permitted in MySQL 5.7). Currently, the only method of identify views with column names that exceed 64 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/trouble.logging.html
Check the tool_name column for the full mysqlbackup command that triggered the backup, including all the options used. Here is information on some columns of the backup_history table, and some ways to make use of the information: The tool_name ...