Search Results
https://dev.mysql.com/doc/internals/en/optimizer-constants-constant-tables.html
unique_not_null_column INT NOT NULL UNIQUE then this expression FROM Table1 ... Here's an example: SELECT Table1.unique_not_null_column, Table2.any_column FROM Table1, Table2 WHERE Table1.unique_not_null_column = Table2.any_column AND ... A MySQL ...
https://dev.mysql.com/doc/internals/en/optimizer-eliminating-dead-code.html
A transformation takes place for conditions that are always true, for example: WHERE 0=0 AND column1='y' In this case, the first condition is removed, leaving WHERE column1='y' See: /sql/sql_select.cc, remove_eq_conds(). Consider the following: ...
https://dev.mysql.com/doc/internals/en/risky-handling-around-additional-sessions.html
This is most probably good for the throughput of usual application but has some annoying consequences for the development of tests. I guess this also applies to the end (-> end of statements to be executed by mysqltest) of a test. It triggers some ...If a disconnect <connection> or KILL <connection_id> or --exec <client program which connects to the server> occurs within a script for mysqltest than the next statements will be executed even if the disconnect or kill is not complete ...
https://dev.mysql.com/doc/internals/en/wait-condition.html
Like 'sleep', this method can also be used, when all but one thread reach a blocked state. If you are able to detect that the threads are in their blocked state by using SQL statements, then you can use this method. Example: --connection conn1 LOCK ...The remaining thread runs the statement(s) until the expected result is ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-blobs-ndbrecord.html
This example illustrates the manipulation of a blob column in the NDB API using the NdbRecord interface. Note While the MySQL data type used in the example is actually TEXT, the same principles apply /* ndbapi_blob_ndbrecord Illustrates the ...It ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-tablemapping.html
fields holds an array of FieldMapping objects;this can also be a single FieldMapping. There is no public constructor for this object; you can create a FieldMapping using TableMapping.mapField(), or you can use FieldMapping literals can be used ... A ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndb-record-structure.html
Again, this is typical of relational databases, and NDB is no different in this regard. This generally means that the transaction encountering a timeout should be rolled back and restarted. This record has a 32-bit primary key which also serves as ... The NDB storage engine used by NDB Cluster is a relational database engine storing records in tables as with other relational database ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-logactivity-category.html
This is only available prior to the 5.1.x plugin and 5.5.x. On versions prior to the 5.1.x plugin and 5.5.x this is the high order 32bit value, on later versions it is the full 64bit LSN value up to which checkpoints have completed. This is only ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.0 (2018-04-19)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-0.html
For more information on the variables added and removed in this release, see Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0. For more information on the variables added and removed in this release, see Server and ... Important It is not possible to upgrade to MySQL Enterprise Monitor 8.0 from versions preceding MySQL Enterprise Monitor ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-overview.html
Deployment of the MySQL Enterprise Transparent Data Encryption (TDE) feature, which protects critical data by enabling data-at-rest encryption, is not covered in this guide. Enabling FIPS (Federal Information Processing Standards) mode, which ...