Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
Where practical, wrap several related data change operations into a single transaction, by issuing SET AUTOCOMMIT=0 or a START TRANSACTION statement, followed by a COMMIT statement after making all the changes. Avoid performing rollbacks after ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. When a new row is inserted into a partitioned table, it is these ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
As an alternative to explicitly escaping special characters, many MySQL APIs provide a placeholder capability that enables you to insert special markers into a statement string, and then bind data values to them when you issue the statement. A ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-index-statistics.html
insert_latency The total wait time of timed inserts into the index. The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
int mysql_session_track_get_first(MYSQL *mysql, enum enum_session_state_type type, const char **data, size_t *length) Description MySQL implements a session tracker mechanism whereby the server returns information about session state changes to ...