Search Results
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
A join buffer is never allocated for the first non-const table, even if it would be of type ALL or index. The buffer is allocated when we need to do a full join between two tables, and freed after the query is done. Accepted row combinations of ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/internals/en/write-row.html
buf is a byte array of data with a size of table->s->reclength You can use the field information to extract the data from the native byte array type. Example of this would be: for (Field **field=table->field ; *field ; field++) { ... } BLOBs must be ...Synopsis virtual int write_row ( buf); byte * buf ; Description This is the write_row ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbscanfilter.html
NdbScanFilter Class Overview NdbScanFilter::begin() NdbScanFilter::BinaryCondition NdbScanFilter::cmp() NdbScanFilter::cmp_param() NdbScanFilter Constructor NdbScanFilter::end() NdbScanFilter::eq() NdbScanFilter::isfalse() NdbScanFilter::isnotnull() ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
16.6: Updating a table that contains a primary key that is either FLOAT or compound primary key that uses FLOAT fails to update the table and raises an exception. The security manager on the MySQL server uses its grant tables to determine whether a ... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. InnoDB tables arrange your data on disk to optimize queries based on primary keys. Each InnoDB table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-moving-data-files-offline.html
The innodb_directories variable, which defines directories to scan at startup for tablespace files, supports moving or restoring tablespace files to a new location while the server is offline. During startup, discovered tablespace files are used ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
In some cases of database corruption, it is enough to dump, drop, and re-create one or a few corrupt tables. You can use the CHECK TABLE statement to check whether a table is corrupt, although CHECK TABLE naturally cannot detect every possible kind ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
Kerberos pluggable authentication provides these capabilities: External authentication: Kerberos authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables who have obtained the proper Kerberos ...
https://dev.mysql.com/doc/refman/8.4/en/nested-loop-joins.html
MySQL executes joins between tables using a nested-loop algorithm or variations on it. Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, passing ...