Search Results
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-myisam.html
That stands for MyISAM, and most of the important files in this directory start with mi. We will begin by mentioning that myisam is one of what we call the MySQL storage engine directories. But the files in those directories are mostly analogues of ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir.html
BUILD client Docs myisam mysys sql vio The orderly approach is to look first at the most important directories, then we'll look at the whole list in our second pass. So, first, let's look at what you'll find in just seven of the directories: BUILD, ...
https://dev.mysql.com/doc/internals/en/header-example.html
# # # # There is important documentation within # # suite/funcs_1/datadict/processlist_val.inc # # # # # # Creation: # # 2007-08-09 mleich Implement this test as part of # # WL#3982 Test information_schema.processlist # # # ... ########### ...
https://dev.mysql.com/doc/internals/en/heap-directory.html
All the MySQL table handlers (that is, the handlers that MySQL itself produces) have files with similar names and functions. Thus, this (heap) directory contains a lot of duplication of the myisam directory (for the MyISAM table handler). Such ...
https://dev.mysql.com/doc/internals/en/implementing-records-in-range-method.html
The [custom-engine.html#custom-engine-api-reference-records_in_range records_in_range()] method is called by the optimizer to assist in choosing which index on a table to use for a query or join. It is defined as follows: ha_rows ...
https://dev.mysql.com/doc/internals/en/implementing-the-info-method.html
delete_length - check_time - When calculating values, speed is more important than accuracy, as there is no sense in taking a long time to give the optimizer clues as to what approach may be the fastest. The optimizer requests an update of table ...
https://dev.mysql.com/doc/internals/en/innodb-overview.html
An Important Note About The Word "Origin" The "Origin" or "Zero Point" of a record is the first byte of the Field Contents --- not the first byte of the Field Start Offsets. The chart below shows the three parts of a physical record. Name Size ...
https://dev.mysql.com/doc/internals/en/logging-transactions-preliminary-rules.html
(PR-causality-precedence) If P-causality and P-durability cannot both be fulfilled, then P-causality is considered more important. The following preliminary rules are actually consequences of the principle that statements shall be correctly logged ...
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
(This is useful when testing whether a table is using the new VARCHAR type or not.) The numeric data types Important: MySQL almost always stores multi-byte binary numbers with the low byte first. Next I'll describe the physical attributes of each ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
The important ones are "the actual length", "the unused length", and "the overflow pointer". MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). These files will be in the directory: ...