Search Results
https://dev.mysql.com/doc/internals/en/extra-directory.html
perror.c --- "print error" --- given error number, display message replace.c --- replace strings in text files or pipe resolve_stack_dump.c --- show symbolic information from a MySQL stack dump, normally found in the mysql.err file resolveip.c --- ...These programs are all standalone utilities, that is, they have a main() function and their main role is to show information that the MySQL server needs or ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...
https://dev.mysql.com/doc/internals/en/gnu-debugger.html
So we'll plow forward, the dull way, noting what's in the directories and using a text editor to note what's in the individual files. Once you've got something that runs, you can put a debugger on it. We recommend use of the GNU debugger ...
https://dev.mysql.com/doc/internals/en/information-schema-optimizer-trace-table.html
TRACE: The trace, in JSON format (see json.org: basically it has scalars (number, string, bool) and structures (either arrays or associative arrays)).
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
It is written as one or more events in a packed format, not as a cleartext statement in the binary log. Consequently, Begin_load_query_log_event is almost the same as Append_file_log_event (it contains only file data), whereas ... LOAD DATA INFILE ...
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
(In this context we can't have a field_length < 256 with a 2-byte pack length) ... When creating a key for the handler, HA_KEYTYPE_VARTEXT1 and HA_KEYTYPE_BINARY1 are used for a key on a column that has a 1-byte length prefix and HA_KEYTYPE_VARTEXT2 ... Next I'll describe the physical attributes of each column in a ...
https://dev.mysql.com/doc/internals/en/mysys-directory.html
There are 125 *.c programs in this directory: array.c --- Dynamic array handling charset.c --- Using dynamic character sets, set default character set, ... For example, the main functions in my_getwd.c are described thus: "int my_getwd _A((string ...
https://dev.mysql.com/doc/internals/en/negative-tests.html
A "negative" test is a test for which you expect to see a failure. If an error does not occur, that itself indicates a problem. DO NOT FORGET "NEGATIVE" TESTS where we expect to see fine error messages from the server. This section contains just a ...
https://dev.mysql.com/doc/internals/en/optimizer-index-join-type.html
An index which is used this way is called a covering index in most texts. Consider this query: SELECT column1 FROM Table1; If column1 is indexed, then the optimizer may choose to retrieve the values from the index rather than from the table. For ...
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...