Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
INFORMATION_SCHEMA tables in MySQL 8.4 are closely tied to the data dictionary, resulting in several usage differences: Previously, INFORMATION_SCHEMA queries for table statistics in the STATISTICS and TABLES tables retrieved statistics directly ...
https://dev.mysql.com/doc/internals/en/index-file-usage.html
While the header of the compressed data file contains a lot of information, there are still some things which need to be taken from the index file. These are the number of columns of the table and the length of each column. The latter is required ...
https://dev.mysql.com/doc/internals/en/optimizer-tracing-typical-usage.html
# Turn tracing on (it's off by default): SET optimizer_trace="enabled=on"; SELECT ...; # your query here SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; # possibly more queries... # When done with tracing, disable it: SET ...
https://dev.mysql.com/doc/internals/en/test-faults-usage.html
SET SESSION debug="+d,function_crash_return"; will crash the server while returning from function.
https://dev.mysql.com/doc/internals/en/tracing-memory-usage.html
It is extended (with realloc()) as optimization progresses and appends data to it. The optimizer_trace_max_mem_size variable sets a limit on the total amount of memory used by all currently remembered traces: If this limit is reached, the current ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. MySQL Enterprise Encryption functions are provided by a MySQL component component_enterprise_encryption. For ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-tracing-typical-usage.html
To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 10.15.3, “Traceable Statements”, for a listing of statements which can be traced. To examine traces for multiple ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging. The type of binary log used impacts the size and efficiency of logging. Therefore the choice between row-based replication (RBR) or statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-memory-usage.html
Each stored trace is a string, which is extended (using realloc()) as optimization progresses by appending more data to it. The optimizer_trace_max_mem_size server system variable sets a limit on the total amount of memory used by all traces ...