List:Internals« Previous MessageNext Message »
From:Baron Schwartz Date:April 12 2009 8:32pm
Subject:Re: Client Authentication Packet w/ databasename
View as plain text  
I see now, thanks!

Baron

On Sun, Apr 12, 2009 at 2:19 PM, Eric Day <eday@stripped> wrote:
> Hi Baron,
>
> It may be a single network packet, but all application packets are
> in there. For me, the single network packet is:
>
> A:           0100 0001 0127 0000 0203 6465    
>  .....'....de
> B: 6600 0000 1140 4076 6572 7369 6f6e 5f63  f....@@version_c
> C: 6f6d 6d65 6e74 000c 0800 1c00 0000 fd01  omment..........
> D: 001f 0000 0500 0003 fe00 0002 001d 0000  ................
> E: 041c 4d79 5351 4c20 436f 6d6d 756e 6974  ..MySQL.Communit
> F: 7920 5365 7276 6572 2028 4750 4c29 0500  y.Server.(GPL)..
> G: 0005 fe00 0002 00                  
>      .......
>
>
> If we break this down into application packets, we'll get the five
> packets below. Note the query was packet #0, and the formatting below
> is setup to match the offsets in the packet above.
>
> Result Set Header Packet: 1 byte, packet #1, 1 column
>
> A:           0100 0001 01          
>             .....
>
>
> Field Packet: 39 bytes (0x27), packet #2
>
> A:                       27
> 0000 0203 6465      .....'....de
> B: 6600 0000 1140 4076 6572 7369 6f6e 5f63  f....@@version_c
> C: 6f6d 6d65 6e74 000c 0800 1c00 0000 fd01  omment..........
> D: 001f 0000                    
>            ....
>
>
> EOF Packet: 5 bytes, packet #3
>
> D:           0500 0003 fe00 0002 00      
>   ...........
>
>
> Row Data Packet: 29 bytes (0x1d), packet #4
>
> D:                      
>           1d 0000            
> .....
> E: 041c 4d79 5351 4c20 436f 6d6d 756e 6974  ..MySQL.Communit
> F: 7920 5365 7276 6572 2028 4750 4c29       y.Server.(GPL)
>
>
> EOF Packet: 5 bytes, packet #5
>
> F:                      
>              0500          
>      ..
> G: 0005 fe00 0002 00                  
>      .......
>
>
> Hope this helps!
>
> -Eric
>
> On Sun, Apr 12, 2009 at 09:36:32AM -0400, Baron Schwartz wrote:
>> Another interesting thing I'm seeing -- it looks to me like the server
>> replies with a single packet to "select @@version_comment limit 1"
>> instead of
>>
>> "The order of packets for a result set is:
>>
>>   (Result Set Header Packet)  the number of columns
>>   (Field Packets)             column
> descriptors
>>   (EOF Packet)              
>  marker: end of Field Packets
>>   (Row Data Packets)          row contents
>>   (EOF Packet)              
>  marker: end of Data Packets"
>>
>> The single packet contains the column definition AND the row data.
>> Comments on that?
>>
>> --
>> MySQL Internals Mailing List
>> For list archives: http://lists.mysql.com/internals
>> To unsubscribe:    http://lists.mysql.com/internals?unsub=1
>



-- 
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
Thread
Client Authentication Packet w/ databasenameBaron Schwartz12 Apr
  • Re: Client Authentication Packet w/ databasenameEric Day12 Apr
    • Re: Client Authentication Packet w/ databasenameBaron Schwartz12 Apr
      • Re: Client Authentication Packet w/ databasenameBaron Schwartz12 Apr
        • Re: Client Authentication Packet w/ databasenameEric Day12 Apr
          • Re: Client Authentication Packet w/ databasenameBaron Schwartz12 Apr
          • Re: Client Authentication Packet w/ databasenameBaron Schwartz12 Apr
            • Re: Client Authentication Packet w/ databasenameEric Bergen13 Apr
              • Re: Client Authentication Packet w/ databasenameKay Röpke14 Apr
                • Re: Client Authentication Packet w/ databasenameBaron Schwartz16 Apr
            • Re: Client Authentication Packet w/ databasenameKristian Nielsen13 Apr
            • Re: Client Authentication Packet w/ databasenameMichael Widenius13 Apr
  • Re: Client Authentication Packet w/ databasenameKonstantin Osipov13 Apr