Search Results
https://dev.mysql.com/doc/internals/en/binlog-event.html
It needs extra events to mimic the client connection's state on the slave side. The events contain the actual data that should be shipped from the master to the slave. Binlog Management The first event is either a START_EVENT_V3 or a ...
https://dev.mysql.com/doc/internals/en/capability-negotiation.html
To permit an old client to connect to newer servers, the initial handshake contains the MySQL Server version the server's capabilities The client should only announce the capabilities in the Handshake Response Packet that it has in common with the ...They can agree on: use of status flags use of SQL states for error-codes authentication methods SSL support ...
https://dev.mysql.com/doc/internals/en/client-directory.html
The C program files in the directory are: get_password.c --- ask for a password from the console mysql.cc --- "The MySQL command tool" mysqladmin.cc --- maintenance of MySQL databases mysqlcheck.c --- check all databases, check connect, etc. The ...
https://dev.mysql.com/doc/internals/en/com-binlog-dump.html
Requests a binlog network stream from the master starting a given position. You can use SHOW BINARY LOGS to get the current logfile and position from the master. The master responds either with a binlog network stream a ERR_Packet or (if ...
https://dev.mysql.com/doc/internals/en/com-init-db.html
COM_INIT_DB: change the default schema of the connection Returns OK_Packet or ERR_Packet Payload 1 [02] COM_INIT_DB string[EOF] schema name Fields command (1) -- 0x02 COM_INIT_DB schema_name (string.EOF) -- name of the schema to change to Example ...
https://dev.mysql.com/doc/internals/en/com-shutdown.html
Note COM_SHUTDOWN is deprecated as of MySQL 5.7.9 and removed in MySQL 8.0.
https://dev.mysql.com/doc/internals/en/compression.html
It is enabled if the server announces CLIENT_COMPRESS in its Protocol::Handshake and the client requests it too in its Protocol::HandshakeResponse packet and after the server finishes Connection Phase, with a OK_Packet. Compression is its own ...
https://dev.mysql.com/doc/internals/en/creating-handlerton.html
Each storage engine has its own memory area (actually a pointer) in the thd, for storing per-connection information. The handlerton (short for handler singleton) defines the storage engine and contains method pointers to those methods that apply to ...
https://dev.mysql.com/doc/internals/en/custom-engine-overview.html
For example: If three connections all start working with the same table, three handler instances will need to be created. The MySQL server is built in a modular fashion: The storage engines manage data storage and index management for MySQL. The ...
https://dev.mysql.com/doc/internals/en/error-messages-storage-engine.html
For example: Got error 788 'Could not connect to remote server fed.bb.pl' from FEDERATED The Got error %d part will be returned in the user's selected language, but the handler-specific one will use English (unless the handler supports returning the ... To add error messages for table handlers, the following example may be ...