Search Results
https://dev.mysql.com/doc/internals/en/com-query-response.html
Note Not all Table Column Types have a representation in the Text or Binary protocol. 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 ...
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/mysqld-version-reference/en/sys-schema-objects.html
The following tables show all sys schema objects available in MySQL Server. An item has a row in the table if it ever existed in any series shown in the table. Introduced: The version or versions in which the item was introduced. Deprecated: The ...
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-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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
INSTALL COMPONENT adds the component to the mysql.component table (an InnoDB table), and the components to load at startup are read from this table, which is only accessible after InnoDB is initialized. Note Loading a log component implicitly using ... In MySQL 8.4, error logging uses the MySQL component architecture described at Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ... Events are processed in a ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is ... The optimizer uses materialization to enable more efficient subquery ...