Search Results
https://dev.mysql.com/doc/internals/en/implementing-the-info-method.html
The optimizer requests an update of table information by calling the [custom-engine.html#custom-engine-api-reference-info handler::info()] method. The info() method does not have a return value, instead it is expected that the storage engine will ...
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
1) In MySQL 3.23, there was only one event: Load_log_event (type code LOAD_EVENT = 6). 2) In MySQL 4.0.0, the file contents were included in the binary log. LOAD DATA INFILE is not written to the binary log like other statements. It is written as ...
https://dev.mysql.com/doc/internals/en/mysys-functions.html
Functions in mysys: (For flags see my_sys.h) int my_copy _A((const char *from, const char *to, myf MyFlags)); Copy file from from to to. int my_rename _A((const char *from, const char *to, myf MyFlags)); Rename file from from to to. int my_redel ...
https://dev.mysql.com/doc/internals/en/rotate-event.html
Binlog::ROTATE_EVENT: The rotate event is added to the binlog as last event to tell the reader what binlog to request next. Post-header if binlog-version > 1 { 8 position } Payload string[p] name of the next binlog .
https://dev.mysql.com/doc/internals/en/semi-sync-replication.html
In MySQL 5.5 replication can optionally be made semi-synchronous instead of the traditionally asynchronous replication. The clients COMMIT (or in auto-commit mode the current statement) waits until _one_ slave acknowledged that it received (not ...
https://dev.mysql.com/doc/internals/en/ssl-handshake.html
server sending Initial Handshake Packet client replying with SSL Connection Request Packet the ususal SSL exchange leading to establishing SSL connection client sends Handshake Response Packet Image description .
https://dev.mysql.com/doc/internals/en/ssl.html
The MySQL Protocol also supports encryption and authentication via SSL. The encryption is transparent to the rest of the protocol and is applied after the data is compressed right before the data is written to the network layer. The SSL suppport is ...
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
MySQL calls [custom-engine.html#custom-engine-api-reference-external_lock handler::external_lock()] for every table it is going to use at the beginning of every statement. Also, if a user calls LOCK TABLES, MySQL will call handler::external_lock ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, here). "rest_of_plan": [ { "database": "test", "table": ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
To rewrite a scalar IN subquery, the Item_in_subselect::single_value_transformer method is used. The scalar IN subquery will be replaced with an Item_in_optimizer item. On a value request (one of val, val_int, or val_str methods) it evaluates the ...