Search Results
https://dev.mysql.com/doc/internals/en/com-query.html
COM_QUERY: A COM_QUERY is used to send the server a text-based query that is executed immediately. The server replies to a COM_QUERY packet with a COM_QUERY Response. The length of the query-string is a taken from the packet length - 1.
https://dev.mysql.com/doc/internals/en/com-stmt-prepare-response.html
17 00 00 02 03 64 65 66 00 00 00 01 3f 00 0c 3f .....def....?..? 00 00 00 00 00 fd 80 00 00 00 00|17 00 00 03 03 ................ 64 65 66 00 00 00 01 3f 00 0c 3f 00 00 00 00 00 def....?..?..... fd 80 00 00 00 00|05 00 00 04 fe 00 00 02 00|1a ...
https://dev.mysql.com/doc/internals/en/com-stmt-prepare.html
COM_STMT_PREPARE creates a prepared statement from the passed query string. The server returns a COM_STMT_PREPARE Response which contains a statement-id which is used to identify the prepared statement.
https://dev.mysql.com/doc/internals/en/complicated-test-support-debugging.html
At various places within your scripts: if ($debug) { --echo # var1: $var1 , var2: $var2, .....
https://dev.mysql.com/doc/internals/en/cs-sect-expired-password.html
All other statements fail with an error like this: mysql> SELECT 1; ERROR 1820 (HY000): You must SET PASSWORD before executing this statement On the protocol side exists a safeguard CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS to protect clients from running ... Since MySQL 5.6.7, a MySQL account can be expired with ALTER USER account PASSWORD ...
https://dev.mysql.com/doc/internals/en/err-instead-of-eof.html
EXPLAIN SELECT * FROM dual; results in 01 00 00 01 0a 18 00 00 02 03 64 65 66 00 00 00 ..........def... 02 69 64 00 0c 3f 00 03 00 00 00 08 a1 00 00 00 .id..?.......... 00 21 00 00 03 03 64 65 66 00 00 00 0b 73 65 6c .!....def....sel 65 63 74 5f 74 ...
https://dev.mysql.com/doc/internals/en/example-several-mysql-packets.html
Executing SELECT repeat("a", 50) results in uncompressed ProtocolText::Resultset like: 01 00 00 01 01 25 00 00 02 03 64 65 66 00 00 00 .....%....def... 0f 72 65 70 65 61 74 28 22 61 22 2c 20 35 30 29 .repeat("a", 50) 00 0c 08 00 32 00 00 00 fd 01 ...
https://dev.mysql.com/doc/internals/en/guided-tour-chunk.html
Now, having finished with our bird's eye view of the source code from the air, let's take the perspective of the worms on the ground (which is another name for MySQL's developer staff -- turn on laugh track here). if (updated && (error <= 0 || ...
https://dev.mysql.com/doc/internals/en/implementing-commit.html
If the server is in auto-commit mode, the storage engine should automatically commit all read-only statements such as SELECT. During a commit operation, all changes made during a transaction are made permanent and a rollback operation is not ...
https://dev.mysql.com/doc/internals/en/implementing-index-read-last-method.html
The [custom-engine.html#custom-engine-api-reference-index_read_last index_read_last()] method works like [custom-engine.html#custom-engine-index-read index_read()] but finds the last row with the current key value or prefix: int ...