Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
The number of indexed columns in a table The number of partitions. Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
The INSTRUMENTED and HISTORY column values for new threads are determined by the contents of the setup_actors table. For information about how to use the setup_actors table to control these columns, see Section 29.4.6, “Pre-Filtering by Thread”.
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
This is where the privilege columns in the grant tables come into play. These privileges can come from any of the user, global_grants, db, tables_priv, columns_priv, or procs_priv tables. (You may find it helpful to refer to Section 8.2.3, “Grant ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-fetch.html
It returns the data in those buffers for all the columns in the current row set and the lengths are returned to the length pointer. All columns must be bound by the application before it calls mysql_stmt_fetch(). Type Length MYSQL_TYPE_TINY 1 ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
The following list enumerates all NDB errors of type AE (Application error). Having a table without primary key uses an autoincremented hidden key, i.e. NDB error code 5002 MySQL error DMEC Error message The process has wrong type. NDB error code ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
This section provides information about the NdbBlob class, which models a handle to a blob column and provides read and write access to blob column values. NdbBlob Class Overview NdbBlob::ActiveHook NdbBlob::blobsFirstBlob() ...This object has a ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API applications. The storage space required for a MySQL CHAR column is determined by ...The MySQL TINYINT, SMALLINT, INT, and BIGINT data types map to NDB types having the same names and storage requirements as their MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
When converting utf8mb3 columns to utf8mb4, you need not worry about converting supplementary characters because there are none. In terms of table structure, these are the primary potential incompatibilities: For the variable-length character data ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. Consider the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-database-objects.html
The maximum number of attributes (that is, columns and indexes) that can belong to a given table is 512. Each BLOB or TEXT column contributes 256 + 8 = 264 bytes to this total; this includes JSON columns. In addition, the maximum offset for a ...