Search Results
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
Method used for authentication is tied to the user account and stored in the plugin column of mysql.user table. Only then server can look-up the mysql.user table and find the authentication method to be used. Client informs about the user account ...
https://dev.mysql.com/doc/internals/en/error-flags.html
In other cases, this flag is mostly tested with thd->really_abort_on_warning() to ensure we don't abort in the middle of an update with not transactional tables. Error functions thd->really_abort_on_warning() This function returns 1 if a warning ...
https://dev.mysql.com/doc/internals/en/external-lock.html
Synopsis virtual int external_lock ( thd, lock_type); THD * thd ; int lock_type ; Description This is the external_lock method. The locking methods for mysql section in lock.cc has additional comments on this topic that may be useful to read. If you ...
https://dev.mysql.com/doc/internals/en/info.html
Currently, this table handler doesn't implement most of the fields really needed. If in a table scan you don't know the number of records it will probably be better to set records to two so you can return as many records as you need. Called in: ...
https://dev.mysql.com/doc/internals/en/logging-transactions.html
It is not always possible to log correctly in statement format when both transactional and nontransactional tables are used in the same transaction. Statements that update temporary tables need special treatment since they are not logged in row ...
https://dev.mysql.com/doc/internals/en/memory-allocation-mysql-server.html
Things in libraries that are outside of MySQL's control (like hash tables). Some objects have their own MEMROOT: TABLE TABLE_SHARE Query_arena st_transactions . The basic logic to use: All things that are used only for the duration of a query are ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ..............1. see the EOF_Packet: 05 00 00 03 fe 00 00 0a 00 with its status-flag being 0a the 2nd resultset: 01 00 00 06 01 17 00 00 ...
https://dev.mysql.com/doc/internals/en/negative-tests.html
String longer than column Limited number of tables, columns, variables, ... Maximum - 1, Maximum, Maximum + 1 Assume an SQL operation that affects the filesystem (LOAD DATA, CREATE SCHEMA or TABLE, backup/restore, ...). A "negative" test is a test ...
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. The make_join_statistics() routine puts together all the information it can find ... 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/optimizer-eliminating-dead-code.html
SELECT * FROM Table1 WHERE column1 = 'Canada'; The optimizer will not eliminate the condition in the query, even though the CREATE TABLE definition makes it an impossible condition. A transformation takes place for conditions that are always true, ...