Search Results
https://dev.mysql.com/doc/internals/en/logging-transactions-definitions.html
To reason about logging different table types, we make some preliminary definitions. (D-T-table) A table that has a transactional engine is called a T-table. (D-N-table) A table that has a nontransactional engine is called an N-table. Note: ...
https://dev.mysql.com/doc/internals/en/open.html
For instance when a request comes in for a select on the table (tables are not open and closed for each request, they are cached). The server opens all tables by calling ha_open() which then calls the handler specific open(). The first parameter is ...Synopsis virtual int open ( name, mode, test_if_locked); const char * name ; int mode ; uint test_if_locked ; Description This is the open ...
https://dev.mysql.com/doc/internals/en/select-union.html
We will need this object to store in every JOIN structure link on it, but we have not (yet) temporary table structure. Create a temporary table for storing union results (if UNION without ALL option, 'distinct' parameter will be passed to the table ...Allocate JOIN structures and execute JOIN::prepare() for every SELECT to get full information about types of elements of SELECT list ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-clusterjhelper.html
Table 4.8 getServiceInstance(Class<T>) Parameter Description cls the class of the factory return the service instance 4.3.1.8.4 getServiceInstance(Class<T>, ClassLoader) public static T getServiceInstance(Class<T> cls, ClassLoader loader); Locate a ... ClusterJHelper provides helper methods to bridge between the API and the ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-query-predicateoperand.html
Table 4.104 between(PredicateOperand, PredicateOperand) Parameter Description lower another PredicateOperand upper another PredicateOperand return a new Predicate 4.3.3.2.3 equal(PredicateOperand) public abstract Predicate equal(PredicateOperand ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-ddlstatementactivity-category.html
Table 8.3 DDL Statement Activity Metrics Target NameName of the OEM TargetAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter Table (Delta) The total number of ALTER TABLE statements executed. Alter Tablespace (Delta) The ... Lists the DDL Statement Activity metrics and provides a brief description of ...
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. This helps MySQL free the table locks early and can be beneficial in cases where it takes a long time to send results to the ... Lists the Statement Processing configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-adminstatementactivity-category.html
Table 6.1 Admin Statement Activity Metrics NameDescriptionAdmin Commands (Delta) The total number of times a COM_PING, or COM_CHANGE_USER have executed on the protocol. Backup Table (Delta) The total number of BACKUP TABLE statements executed.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-ddlstatementactivity-category.html
Table 6.5 DDL Statement Activity Metrics NameDescriptionAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter Table (Delta) The total number of ALTER TABLE statements executed. Alter Tablespace (Delta) The total number of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...