Search Results
https://dev.mysql.com/doc/internals/en/threads.html
Threads in mysqld can run at four different priorities, defined in mysql_priv.h: #define INTERRUPT_PRIOR 10 #define CONNECT_PRIOR 9 #define WAIT_PRIOR 8 #define QUERY_PRIOR 6 Some threads try to set their priority; others don't. These calls are ...
https://dev.mysql.com/doc/internals/en/too-greedy-test.html
Let's assume we have to check that every new created table causes a row in information_schema.tables. --replace_column 15 <CREATE_TIME> 16 <UPDATE_TIME> 17 <CHECK_TIME> SELECT * FROM information_schema.tables; The SELECT above makes the test ...It ...
https://dev.mysql.com/doc/internals/en/transactions-historical-note.html
MySQL would create a nested transaction at the start of each SQL statement, and destroy (commit or abort) the nested transaction at statement end. "Statement transaction" is a non-standard term that comes from the days when MySQL supported the ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
To rewrite a scalar IN subquery, the Item_in_subselect::single_value_transformer method is used. The scalar IN subquery will be replaced with an Item_in_optimizer item. On a value request (one of val, val_int, or val_str methods) it evaluates the ...
https://dev.mysql.com/doc/internals/en/tuning-trace-purging.html
For example, OFFSET=0 and LIMIT=5 will use memory to remember 5 traces, so if only the three first are needed, OFFSET=0 and LIMIT=3 is better (tracing stops after LIMIT traces, so the 4th and 5th trace are not created and take up no memory). This ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
In case one command creates an error, all following commands should fail too and therefore it is possible to relate the errors to the right messages. Topics in this section: Message Structure Message Sequence Common Messages Connection Session ...
https://dev.mysql.com/doc/internals/en/x-protocol-use-cases-use-cases.html
Optimizing for Network Round-Trips (Assuming the MySQL Client/Server Protocol in this case) Network round-trips can be minimized by creating a huge SQL statements of up to 1Gbyte in chunks of 16Mbyte (the protocol's maximum frame size) and sending ... Topics in this section: Prepared Statements with Single Round-Trip Streaming Inserts SQL with Multiple Resultsets Inserting CRUD Data in a Batch Cross-Collection Update and Delete Prepared Statements with Single Round-Trip In the MySQL Client/Server Protocol, a PREPARE/EXECUTE cycle required two round-trips as the COM_STMT_EXECUTE requires data from the COM_STMT_PREPARE-ok ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
Table 4.42 getResultList() Parameter Description return the result Exceptions ClusterJUserException if not all parameters are bound ClusterJDatastoreException if an exception is reported by the datastore 4.3.1.19.14 setLimits(long, long) public ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-clusterjtableexception.html
Commonly, a Cluster/J application may expect a table to exist, but have to wait some unspecified amount of time for some other system to create the table. Before Cluster/J version 9.4.0, some "Table Not Found" conditions were reported using ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-query-querybuilder.html
4.3.3.3.1 Synopsis public interface QueryBuilder {// Public Methods public abstract QueryDomainType<T> createQueryDefinition(Class<T> cls);} See Also getQueryBuilder() 4.3.3.3.2 createQueryDefinition(Class<T>) public abstract QueryDomainType<T> ...