Search Results
https://dev.mysql.com/doc/internals/en/character-set.html
A given collation implies the character set and the names of both can be seen in the INFORMATION_SCHEMA COLLATIONS table. MySQL has a very flexible character set support as documented in Character Sets, Collations, Unicode. Number Hex Character Set ...
https://dev.mysql.com/doc/internals/en/com-field-list.html
COM_FIELD_LIST: get the column definitions of a table Payload 1 [04] COM_FIELD_LIST string[NUL] table string[EOF] field wildcard Returns COM_FIELD_LIST response Implemented By mysql_list_fields() . Note As of MySQL 5.7.11, COM_FIELD_LIST is ...
https://dev.mysql.com/doc/internals/en/creating-index-keys.html
As part of every table-write operation (INSERT, UPDATE, DELETE), the storage engine is required to update its internal index information. In general, the storage engine will have to use row information passed in methods such as ...The method used ...
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/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 ...