https://davidzhu.xyz/2023/07/12/Database/primary-key/index.html

[utterances-bot]

Primary Key | 橘猫小八的鱼

Primary KeyIndexIndexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant row

https://davidzhu.xyz/2023/07/12/Database/primary-key/index.html

[shwezhu]

After pasting the characters "rights" segment 1 is the send of the character 'r' and segment 2 is the echo of 'r' and ack of segment 1. Even though the remaining characters 'ights' are ready to send, but they cannot be sent until the ack in seg 2 returns. This is Nagle Algorithm.

[shwezhu]

In segment 3 the remaining 5 characters are sent, then echoed in segment 4 and ack of the echo is segment 5.

[shwezhu]

After the 3 way handshake, we see that 1 segment is sent and when the ack returns for that segment the client sends 2 segments in a row. The next ack 4345 covers the two segments that were sent. This is "ack every other segment". At this point the client sends three segments in a row. This shows the case of more than 2 unacknowledged segments being sent.

[shwezhu]

We see many window size changes as noted in tepdump output. We also observed window updates as noted in topdump output.

[shwezhu]

The throughput is approximately 1000 KBps. RTT is approximately 23 ms. The product is 1000 KBps * 23 ms = 23000 bytes which is approximately the receiver's window (23168).