Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-locks.html
The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current lock. The mode column shows the lock mode; this is always one of S (indicating a shared lock) or X (an exclusive ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
Forward Engineering and Synchronization SQL_MODE to be used in generated scripts: Defines the SQL_MODE used by Forward Engineering and Synchronization. Length of ENUMs and SETs to Display: [20] Show Column Flags Shows column flags, such as NOT NULL ... This section provides configuration options that affect the modeling functionality in MySQL Workbench (see the figure that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
For example, you might hit this limit with a column prefix index of more than 191 characters on a TEXT or VARCHAR column, assuming a utf8mb4 character set and the maximum of 4 bytes for each character. The limits that apply to index key prefixes ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-locks.html
The transaction ID shown in the transid column is the identifier generated by the NDB API for the transaction requesting or holding the current lock. The mode column shows the lock mode, which is always one of S (shared lock) or X (exclusive lock).
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
Right-clicking on a schema provides similar options to the table context menu (see Table, view, and column context menus), but the operations refer to the schema. If enabled, the import operation makes a spatial index around the geometry column. It ... The Navigator area of the sidebar contains options to manage the active MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
A cluster size estimate is generated using MySQL HeatWave Autopilot machine learning techniques. Table 4-1 Cluster Size Table Warnings Table Status Issue Description TOO MANY COLUMNS TO LOAD The table has too many columns. ALL COLUMNS MARKED AS NOT ... Estimating Cluster Memory Size with MySQL HeatWave Autopilot 4.1.1 Estimating Cluster Memory Size with MySQL HeatWave Autopilot This topic describes how to estimate the optimal MySQL HeatWave Cluster size for your ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For the latter types, the BINARY attribute does not cause ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
Descending indexes are supported for ordinary (nongenerated) and generated columns (both VIRTUAL and STORED). Descending indexes also make it possible for the optimizer to use multiple-column indexes when the most efficient scan order mixes ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
The error_log table supports focused queries based on its more structured columns. row *************************** LOGGED: 2020-08-06 09:25:03.112801 THREAD_ID: 0 PRIO: System ERROR_CODE: MY-013292 SUBSYSTEM: Server DATA: Admin interface ready for ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
UNION ALL queries with an ORDER BY or LIMIT clause, between dictionary-encoded columns, or between ENUM columns. EXCEPT, EXCEPT ALL, INTERSECT, INTERSECT ALL, and UNION queries with or without an ORDER BY or LIMIT clause, between dictionary-encoded ...For a list of supported SQL modes, see Section 5.2, “Supported SQL ...