Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-set-local-infile-handler.html
void mysql_set_local_infile_handler(MYSQL *mysql, int (*local_infile_init)(void **, const char *, void *), int (*local_infile_read)(void *, char *, unsigned int), void (*local_infile_end)(void *), int (*local_infile_error)(void *, char*, unsigned ...It enables application programs to exert control over local (client-side) data file ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/using-own-protocol-trace-plugins.html
static int plugin_init(char *errbuf, size_t errbuf_len, int argc, va_list args) { return 0; } static int plugin_deinit() { return 0; } static int plugin_options(const char *option, const void *value) { return 0; } The trace-specific members of the ... Note To use your own protocol trace plugins, you must configure MySQL with the WITH_TEST_TRACE_PLUGIN CMake option disabled because only one protocol trace plugin can be loaded at a time and an error occurs for attempts to load a second ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
That will be the case if there are BLOB columns, or "true"VARCHAR columns. (Remember that MySQL may treat VARCHAR columns as if they're CHAR columns, in which case the fixed format is used.) A dynamic row has more fields in the header. "True ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
rest of the 1024-byte block is unused From the above illustrations, these facts should be clear: Each key contains the entire contents of all the columns, including trailing spaces in CHAR columns. Even for a fixed CHAR(3) column, the size of the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-timestamp2.html
The file timestamp2.cpp reproduced in this section provides an example of working in NDB API applications with the “new” MySQL temporal data types supporting fractional seconds. For more information working with MySQL temporal and other data ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
The storage space required for a MySQL CHAR column is determined by the maximum number of characters and the column's character set. For most (but not all) character sets, each character takes one byte of storage. When using utf8, each character ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary strings. This means they have the binary character set and collation, and comparison and sorting are based on the numeric ...
https://dev.mysql.com/doc/refman/8.4/en/charset-national.html
Standard SQL defines NCHAR or NATIONAL CHAR as a way to indicate that a CHAR column should use some predefined character set. For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
A typical use case for the MEMORY engine involves these characteristics: Operations involving transient, non-critical data such as session management or caching. Performance Characteristics MEMORY performance is constrained by contention resulting ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...