Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-server-authentication.html
If the truststore file does not already exist, a new one will be created; otherwise the certificate will be added to the existing file. The next step is to configure Java or Connector/J to read the truststore you just created or modified. Setting ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-connpooling.html
When this is the case, it usually makes sense to create a pool of database connections available for web requests as needed. Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-vb.html
The following sample creates a table my_vb_net and demonstrates the use in VB.
https://dev.mysql.com/doc/internals/en/binlog-event-flag.html
Hex Flag 0x0001 LOG_EVENT_BINLOG_IN_USE_F 0x0002 LOG_EVENT_FORCED_ROTATE_F 0x0004 LOG_EVENT_THREAD_SPECIFIC_F 0x0008 LOG_EVENT_SUPPRESS_USE_F 0x0010 LOG_EVENT_UPDATE_TABLE_MAP_VERSION_F 0x0020 LOG_EVENT_ARTIFICIAL_F 0x0040 LOG_EVENT_RELAY_LOG_F ...
https://dev.mysql.com/doc/internals/en/determining-logging-format.html
The sp_head object stores the Lex that was generated when the statement defining the sub-statement was parsed (that is, when CREATE FUNCTION/CREATE PROCEDURE/CREATE TRIGGER/CREATE VIEW/PREPARE was parsed). For each statement, we must determine the ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). "Filler Bits" = 1 The length of the record header is thus: (1 + number of NULL columns + 7) / 8 bytes After the header, all columns are ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Suppose that we have a partitioned table with N columns, using partitioning type p_type and the partitioning function p_func, represented like this: CREATE TABLE t (columns) PARTITION BY p_type(p_func(col1, col2,... 7.3.2.1.2.2 Interval Walking Let ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...
https://dev.mysql.com/doc/internals/en/prepared-stored-statement-execution.html
We don't want the garbage created during execution to be left in the permanent arena of the statement. The execution plan created at prepare stage is not saved (see Section 17.2, “Preparation of a Prepared Statement”), and at execute we simply ... In order to call mysql_execute_command (the function that executes a statement) for a prepared statement and not damage its parse tree, we backup and restore the active Query_arena of ...
https://dev.mysql.com/doc/internals/en/select-union.html
Create a temporary table for storing union results (if UNION without ALL option, 'distinct' parameter will be passed to the table creation procedure). Assign a temporary table to the select_union object created in the first step. A special ...We ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
To insert a new row into the table, first create a new instance of Employee. The savePersistent() method updates an existing instance or creates a new instance as needed, without throwing an exception. The process begins with obtaining an instance ...This can be accomplished by calling the Session method newInstance(), as shown here: Employee newEmployee = session.newInstance(Employee.class); Set the Employee instance properties corresponding with the desired employee table ...