Search Results
https://dev.mysql.com/doc/internals/en/unsafe-statements.html
Update from a sub-statement of a table that has an autoincrement column. This is unsafe because the Intvar_log_event is limited to only hold autoincrement values for one table. Statements referencing system log tables, since the contents of those ...
https://dev.mysql.com/doc/internals/en/variation-of-storage-engine.html
Checks of the INFORMATION_SCHEMA The storage engines to be used for information_schema tables are hardcoded. when selecting on INFORMATION_SCHEMA tables should not run with storage engine variations. That means mostly: DO NOT use hardcoded storage ...Therefore tests focussed on permissions, optimizer strategies, column data types ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-basic-delete.html
This example shows deleting a row from a table already created and populated previously (see Section 2.5.1.2, “NDB API Basic Insertion Example”). It performs the deletion using a single NdbOperation within a transaction, and handles errors ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-event-handling.html
#include <NdbApi.hpp> // Used for cout #include <stdio.h> #include <iostream> #include <unistd.h> #ifdef VM_TRACE #include <my_global.h> #endif #ifndef assert #include <assert.h> #endif /** * Assume that there is a table which is being updated by * ...The source code for this program may be found in the NDB Cluster source tree, in the file ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes.html
This program illustrates how to use secondary indexes in the NDB API. The source code for this example may be found in the NDB Cluster source tree, in storage/ndb/ndbapi-examples/ndbapi_simple_index/main.cpp.
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-mynode.html
You can get the mapping either by name, or by using an existing mapping: TableMapping(tableName); TableMapping(tableMapping); openSession(properties, mappings, Function(err, Session) callback); Connect to the data source and get a Session in the ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndb-record-structure.html
The NDB storage engine used by NDB Cluster is a relational database engine storing records in tables as with other relational database systems. When a new table is created, its attribute schema is specified for the table as a whole, and thus each ...Again, this is typical of relational databases, and NDB is no different in this ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-13-2-4-0-0.html
For more information on the variables added and removed in MySQL 8, see Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 The following metrics were added for MySQL 8 support: Sys Schema Table Metadata Lock Waits ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-database-processes.html
Table 3.1 Database Processes Dashboard Name Description Thread ID The thread ID. Full Scan The number of full table scans performed by the current statement. Tmp Disk Tables The number of internal on-disk temporary tables created by the current ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-locking.html
Table 3.2 InnoDB Row Lock Waits Dashboard Name Description Waiting Lock ID The ID of the waiting lock. Table Metadata Lock Waits This dashboard displays which sessions are blocked waiting on metadata locks, and what is blocking them. Table 3.3 Table ... InnoDB Row Lock Waits Displays the InnoDB locks transactions are waiting ...