Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/internals/en/dbug-sleep.html
In cases where the normal server code does not have a block point at the critical place, one can insert an artificial synchronization point. If this is not possible, the test must be moved into a test file that includes 'have_debug.inc'.
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"). These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, here). "rest_of_plan": [ { "database": "test", "table": ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes-ndbrecord.html
*/ NdbDictionary::RecordSpecification spec[2]; spec[0].column= col1; spec[0].offset= offsetof(MyTableRow, attr1); // So that it goes nicely into the struct spec[0].nullbit_byte_offset= 0; spec[0].nullbit_bit_in_byte= 0; const NdbRecord *pk_record= ... This program illustrates how to use secondary indexes in the NDB API with the aid of the NdbRecord ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Buffer Result Enabled If set to 1, sql_buffer_result forces results from SELECT statements to be put into temporary tables. When this amount of space is used for computing the digest for a statement, no further tokens from the parsed statement are ... Lists the Statement Processing configuration metrics and provides a brief description of ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.1 (2018-07-24)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-1.html
For example, searching for INSERT INTO `mem__quan` resulted in the string INSERT+INTO+`mem__quan`. Functionality Added or Changed Bugs Fixed Functionality Added or Changed The usability of the Context and Target selection fields has been improved.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-modify.html
For example: arrayInsert("favorNums[1]", 7), arrayInsert("favorNums[1]", {even: 2, odd: 3, irrational: 'pi'}). If DocPath identifies an array position past the end of an array, the value is inserted at the end of the array. The ...