Search Results
https://dev.mysql.com/doc/internals/en/example-one-mysql-packet.html
A COM_QUERY for select "012345678901234567890123456789012345" without CLIENT_COMPRESS has a payload length of 46 bytes looks like: 2e 00 00 00 03 73 65 6c 65 63 74 20 22 30 31 32 .....select "012 33 34 35 36 37 38 39 30 31 32 33 34 35 36 37 38 ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-sql.html
If you remember your manual, you know that you must pronounce this: ess queue ell. The "parser" programs on mysql-5.0/sql: size name comment ---- ---- ------- 51326 sql_lex.cc lexer 230026 sql_yacc.yy parser + many more *.cc programs This is where ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
And now we're going to walk through something harder, namely the server. WARNING WARNING WARNING: code changes constantly, so names and parameters may have changed by the time you read this. Important files we'll be walking through: /sql/mysqld.cc ...
https://dev.mysql.com/doc/internals/en/item-class.html
To us, the word Item means more than just “thingamabob”; it is a technical term with a precise definition in the context of our source code. In the function category we include operators such as + and ||, because operators are merely functions ...
https://dev.mysql.com/doc/internals/en/optimizer-constants-constant-tables.html
A MySQL constant is something more than a mere literal in the query. unique_not_null_column INT NOT NULL UNIQUE then this expression FROM Table1 ... These rules mean that a constant table has at most one row value. MySQL will evaluate a constant ...
https://dev.mysql.com/doc/internals/en/optimizer-definitions.html
This description uses a narrow definition: The optimizer is the set of routines which decide what execution path the DBMS should take for queries. MySQL changes these routines frequently, so you should compare what is said here with what's in the ...
https://dev.mysql.com/doc/internals/en/optimizer-tracing-typical-usage.html
# Turn tracing on (it's off by default): SET optimizer_trace="enabled=on"; SELECT ...; # your query here SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; # possibly more queries... # When done with tracing, disable it: SET ...
https://dev.mysql.com/doc/internals/en/prepared-stored.html
Let us start with a general description of the MySQL statement processing workflow in order to provide the reader with understanding of the problem of reexecution and vocabulary for the following sections. Conventional statements, that is, SQL ...
https://dev.mysql.com/doc/internals/en/row-order-within-result-sets.html
Please keep in mind that the row order within a significant number of result sets depends on storage engine properties and in worst cases the current load (NDB!, partitioning?, parallel query?) on the testing box. Either use --sorted_result SELECT ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...