Search Results
https://dev.mysql.com/doc/internals/en/libmysqld-directory.html
The product of libmysqld is not a client/server affair, but a library. The program files on this directory are: libmysqld.c --- The called side, compare the mysqld.exe source lib_sql.c --- Emulate the vio directory's communication buffer .
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
Lost in the mysteries of time is the knowledge of whether there was ever a server version capable of writing NEW_LOAD_EVENT. LOAD DATA INFILE is not written to the binary log like other statements. It is written as one or more events in a packed ...
https://dev.mysql.com/doc/internals/en/mysql-packet.html
If a MySQL client or server wants to send data, it: Splits the data into packets of size (224−1) bytes Prepends to each chunk a packet header Protocol::Packet Data between client and server is exchanged in packets of max 16MByte size. The number ...
https://dev.mysql.com/doc/internals/en/old-password-authentication.html
Authentication::Old: auth_method_name is mysql_old_password client-side requires "8-byte random challenge" from server client-side sends a 8-byte response based on the algorithm described later Note If the server announces Secure Password ...Image ...
https://dev.mysql.com/doc/internals/en/plugins.html
Beginning with MySQL 5.1, the server supports a plugin architecture for loading plugins. You can build a plugin as static (compiled into the server) or dynamic (built as a dynamic library that must be installed using the INSTALL PLUGIN statement or ...For example, several storage engines have been converted to plugins, and they can be selected or disabled at configuration ...
https://dev.mysql.com/doc/internals/en/prepared-stored-statement-preparation.html
As mentioned above, THD is currently a required argument and the runtime context for every function in the server. In a clean implementation this would belong to a separate step, but in our case the majority of the server runtime was not refactored ...Therefore, in order to call the parser and allocate memory in the statement memory root we perform several save-restore steps with THD::mem_root and THD::free_list (the active arena of ...
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/query-event.html
Binlog::QUERY_EVENT: The query event is used to send text querys right the binlog. Post-header 4 slave_proxy_id 4 execution time 1 schema length 2 error-code if binlog-version ≥ 4: 2 status-vars length Payload string[$len] status-vars ...
https://dev.mysql.com/doc/internals/en/risky-handling-around-additional-sessions.html
If a disconnect <connection> or KILL <connection_id> or --exec <client program which connects to the server> occurs within a script for mysqltest than the next statements will be executed even if the disconnect or kill is not complete finished. (2) ...This is most probably good for the throughput of usual application but has some annoying consequences for the development of ...
https://dev.mysql.com/doc/internals/en/rnd-next.html
Purpose Reads the next row from a table and returns it to the server. The Field structure for the table is the key to getting data into buf in a manner that will allow the server to understand it. Synopsis virtual int rnd_next ( buf); byte * buf ; ...