https://dev.mysql.com/innodb-online-ddl-performance.html
Minimizing load helps maintain good performance and high throughput during the DDL operation. Online operations read less data into the buffer pool than table-copy operations, which reduces purging of frequently accessed data from memory. Online DDL ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/json-search-functions.html
Two scalar values are comparable if they have the same JSON_TYPE() types, with the exception that values of types INTEGER and DECIMAL are also comparable to each other. The functions in this section perform search or comparison operations on JSON ...
https://dev.mysql.com/locking-service-udf-interface.html
This section describes how to use the locking service user-defined function (UDF) interface. To use the C language interface instead, see Section 29.3.1.1, “The Locking Service C Interface” For general characteristics of the locking service ...
https://dev.mysql.com/merge-storage-engine.html
You can optionally specify an INSERT_METHOD option to control how inserts into the MERGE table take place. If you specify no INSERT_METHOD option or if you specify it with a value of NO, inserts into the MERGE table are not permitted and attempts to ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/miscellaneous-functions.html
INET_ATON(expr) Given the dotted-quad representation of an IPv4 network address as a string, returns an integer that represents the numeric value of the address in network byte order (big endian). Note To store values generated by INET_ATON(), use ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. Important When ...
https://dev.mysql.com/mysql-cluster-ndbd-definition.html
For data nodes, this is an integer in the range 1 to 48 inclusive. The NodeGroup parameter is chiefly intended for use in adding a new node group to a running NDB Cluster without having to perform a rolling restart. Communication between nodes in ...
https://dev.mysql.com/mysql-fetch-field-direct.html
MYSQL_FIELD *mysql_fetch_field_direct(MYSQL_RES *result, unsigned int fieldnr) Given a field number fieldnr for a column within a result set, returns that column's field definition as a MYSQL_FIELD structure. unsigned int num_fields; unsigned int ...Use this function to retrieve the definition for an arbitrary ...
https://dev.mysql.com/mysql-fetch-row.html
If row holds the return value from a call to mysql_fetch_row(), pointers to the values are accessed as row[0] to row[mysql_num_fields(result)-1]. Empty fields and fields containing NULL both have length 0; you can distinguish these by checking the ...Its asynchronous counterpart is mysql_fetch_row_nonblocking(), for use by applications that require asynchronous communication with the ...
https://dev.mysql.com/mysql-field-count.html
unsigned int mysql_field_count(MYSQL *mysql) Returns the number of columns for the most recent query on the connection. The normal use of this function is when mysql_store_result() returned NULL (and thus you have no result set pointer). An ...In ...
