Search Results
https://dev.mysql.com/doc/internals/en/myisam-dynamic-data-file-layout.html
When a record is inserted after this, it reuses the old frame. The rest is inserted in other old frames, or, if non is available, in a new frame at end of file. A record can be put in one or more frames, also called the record "parts" or "blocks".
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"). These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...
https://dev.mysql.com/doc/internals/en/packet-OK_Packet.html
An OK packet is sent from the server to the client to signal successful completion of a command. As of MySQL 5.7.5, OK packes are also used to indicate EOF, and EOF packets are deprecated. Consequently, the server does not send OK packets that ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
That is, if an INSERT fires a trigger, which calls a stored procedure, that invokes a stored method, and so forth, all tables used in the trigger, stored procedure, method, etc., are locked in the beginning of the INSERT. MySQL calls ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, here). "rest_of_plan": [ { "database": "test", "table": ...
https://dev.mysql.com/doc/internals/en/unsafe-statements.html
INSERT DELAYED, since the rows inserted may interleave with concurrently executing statements. NOTE: the following list is incomplete; it does not take into account changes made in 2010 or later (roughly). An unsafe statement will be logged in row ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-column.html
4.3.2.1.1 Synopsis @Target(value={java.lang.annotation.ElementType.FIELD, java.lang.annotation.ElementType.METHOD}) @Retention(value=java.lang.annotation.RetentionPolicy.RUNTIME) public @interface Column { public String name ; public String ...This ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-basic-read.html
We assume that you have already created and populated the basic table, perhaps using the row insertion example shown previously (see Section 2.5.1.2, “NDB API Basic Insertion Example”). This example illustrates basic retrieval of one or more ...