Search Results
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/innodb-page-example.html
Skipping past the User Records and the Free Space, many bytes later, is the end of the 16KB page. For this example, I used Borland's TDUMP again, as I did for the earlier chapter on Record Format. This is what a page looked like: Address Values in ...
https://dev.mysql.com/doc/internals/en/innodb-page-header.html
The PAGE_FREE pointer in the page header points to the first record in the list. The "next" pointer in the record header (specifically, in the record's Extra Bytes) points to the next record in the list. PAGE_DIRECTION and PAGE_N_DIRECTION: It's ...
https://dev.mysql.com/doc/internals/en/man-directory.html
Some user-contributed manual pages These are user-contributed "man" (manual) pages in a special markup format. The format is described in a document with a heading like "man page for man" or "macros to format man pages" which you can find in a ...
https://dev.mysql.com/doc/internals/en/miscellaneous-options.html
For Autotools MySQL build options that have CMake equivalents, the normal mapping from an Autotools option to the CMake option is to convert uppercase, remove leading dashes, replace dashes with underscores, and add a leading -D.
https://dev.mysql.com/doc/internals/en/optimizer-code.html
*/ optimize_cond() opt_sum_query() make_join_statistics() get_quick_record_count() choose_plan() /* Find the best way to access tables */ /* as specified by the user. */ optimize_straight_join() best_access_path() /* Find a (sub-)optimal plan among ... This diagram shows the structure of the function handle_select() in /sql/sql_select.cc (the server code that handles a query): handle_select() mysql_select() JOIN::prepare() setup_fields() JOIN::optimize() /* optimizer is from here ...
https://dev.mysql.com/doc/internals/en/preventing-use-of-optimizer-trace.html
If for some reason, as DBA of a MySQL Server, you wish to prevent all users from seeing traces of their queries, start the server with these options: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum ...
https://dev.mysql.com/doc/internals/en/risky-handling-around-additional-sessions.html
This is most probably good for the throughput of usual application but has some annoying consequences for the development of tests. If a disconnect <connection> or KILL <connection_id> or --exec <client program which connects to the server> occurs ...
https://dev.mysql.com/doc/internals/en/transactions-current-situation.html
The normal transaction is started by the user and is usually completed by a user request as well. Nowadays a statement transaction is started for each statement that accesses transactional tables or uses the binary log. Commits of statement ...
https://dev.mysql.com/doc/internals/en/variation-of-protocol-option.html
We have a lot of tests running very similar and extremely simple SQL just for the creation of a situation to be tested, check of table content, etc. It is usual to run tests with and without the mysql-test-run.pl startup option "--ps-protocol". And ...