Search Results
https://dev.mysql.com/doc/internals/en/com-query-response.html
Image description If it is not a valid Protocol::LengthEncodedInteger it is either a ERR_Packet or a Protocol::LOCAL_INFILE_Request. Image description 14.6.4.1.1 Text Resultset A Text Resultset is a possible COM_QUERY Response. It is made up of two ...
https://dev.mysql.com/doc/internals/en/debug-sync-facility.html
MySQL supports a Debug Sync Facility, which - in spite of the "debug" in its name - is completely independent from the DBUG facility (except that it uses DBUG to trace its operation, if DBUG is also configured in the server). The documentation here ...
https://dev.mysql.com/doc/internals/en/innodb-field-contents.html
The Field Contents part of the record has all the data. There are no markers between fields, and there is no marker or filler at the end of a record. I made a table with this definition: CREATE TABLE T (FIELD1 VARCHAR(3), FIELD2 VARCHAR(3), FIELD3 ...
https://dev.mysql.com/doc/internals/en/nicely-displaying-trace.html
Looking at a trace in the mysql command-line client can be cumbersome (though the pager less command makes it better). An alternative can be to send the trace to a file: SELECT TRACE INTO DUMPFILE <filename> FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; ...
https://dev.mysql.com/doc/internals/en/optimizer-index-merge-join-type.html
7.2.2.5.1 Overview Index Merge is used when table condition can be converted to form: cond_1 OR cond_2 ... OR cond_N The conditions for conversion are that each cond_i can be used for a range scan, and no pair (cond_i, cond_j) uses the same index.
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-converter.html
If the user supplies a JavaScript converter, it used to read and write to the database. fromDB(val): Convert a value val read from the database into application object format. Converter invocations are chained in the following ways: When writing to ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-common-files.html
In the NDB Cluster source distribution, the storage/ndb/ndbapi-examples directory storage/ndb/ndbapi-examples/common contains four header files with utilities for use in example NDB API programs. (Bug #70550, Bug #17592990) The names of these files ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-innodbactivity-category.html
Lists the InnoDB Activity metrics and provides a brief description of each. Table 8.8 InnoDB Activity Metrics NameDescriptionTarget Name Name of the OEM Target Buffer Pool Pages Flushed (Delta) The number of buffer pool page-flush requests. Buffer ...
https://dev.mysql.com/doc/mysql-em-plugin/en/ui-myoem-homepage-regions.html
This section describes the regions displayed on the MySQL Database target homepage. The following regions are available: Availability History Configuration Summary Connections Transaction Activity Row Activity InnoDB Buffer Pool Usage (pages) ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
For optimal performance, transactions that move through the binary log should be contained within the binary log cache. For more information on the binary log and binary log cache, see The Binary Log. Default frequency 00:05:00 Default auto-close ...