Search Results
https://dev.mysql.com/doc/internals/en/implementing-rnd-init-method.html
The method called before any table scan is the [custom-engine.html#custom-engine-api-reference-rnd_init rnd_init()] method. The rnd_init() method is used to prepare for a table scan, resetting counters and pointers to the start of the table. The ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). (Reminder: This does not refer to BDB and InnoDB tables, which do use pages). So the file Table1.MYD looks like this: Hexadecimal Display of ...These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the /usr/local/var/test directory (assuming your database name is ...
https://dev.mysql.com/doc/internals/en/optimizer-transpositions.html
If an expression of this form refers to an indexed column, then MySQL always uses the index, regardless of the table size. (Exception: If the table has only zero rows or only one row, it is a constant table and receives special treatment. MySQL ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-context.html
find(Function constructor, Object keys, Function(Object error, Object instance[, ...]) callback[, ...]); find(String tableName, Object keys, Function(Object error, Object instance[, ...]) callback[, ...]); Find a specific instance based on a primary ...It contains functions that are executed immediately if called from a session, or when the batch is ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-13-2-1-0-0.html
Sys Schema Table Metadata Lock Waits: based on the schema_table_lock_waits sys schema view. For more information, see Section 6.41, “Sys Schema Table Metadata Lock Waits Metrics”. Sys Schema Table Statistics: based on the schema_table_statistics ... Important This version requires the Oracle Enterprise Manager Extensibility Development Kit ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
Note You can enable binary logging of compressed transactions for tables using the NDB storage engine at run time using the ndb_log_transaction_compression system variable, and control the level of compression using ... MySQL supports binary log ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_advertise_recovery_endpoints specifies how a joining member can establish a connection to an existing member for state transfer for distributed recovery. The Performance Schema table replication_group_members shows this ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-nodes-groups.html
However, it is also possible to employ user-defined partitioning with NDBCLUSTER tables. This is subject to the following limitations: Only the KEY and LINEAR KEY partitioning schemes are supported in production with NDB tables. The maximum number ... This section discusses the manner in which NDB Cluster divides and duplicates data for ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
As connections are established, the thread pool assigns them to thread groups in round-robin fashion. A statement becomes blocked if it encounters a disk I/O operation or a user level lock (row lock or table lock). Thus, given a mix of statements ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. However, whereas an aggregate operation groups query rows into a single result row, a ...