dig090

Read-Write Hibernate Transaction Tcpdump

Jan 14th, 2016
535
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.44 KB | None | 0 0
  1. 16:02:09.858472 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [P.], seq 2802732079:2802732084, ack 3994276526, win 4096, options [nop,nop,TS val 929388002 ecr 2384000281], length 5
  2. 16:02:09.878780 IP 10.35.215.20.3306 > 10.8.0.6.60541: Flags [P.], seq 1:12, ack 5, win 249, options [nop,nop,TS val 2384023344 ecr 929388002], length 11
  3. 16:02:09.878848 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [.], ack 12, win 4095, options [nop,nop,TS val 929388022 ecr 2384023344], length 0
  4. 16:02:09.879288 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [P.], seq 5:26, ack 12, win 4096, options [nop,nop,TS val 929388022 ecr 2384023344], length 21
  5. SET.autocommit=0
  6. 16:02:09.898855 IP 10.35.215.20.3306 > 10.8.0.6.60541: Flags [P.], seq 12:23, ack 26, win 249, options [nop,nop,TS val 2384023349 ecr 929388022], length 11
  7. 16:02:09.898900 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [.], ack 23, win 4095, options [nop,nop,TS val 929388041 ecr 2384023349], length 0
  8. 16:02:09.956200 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [P.], seq 26:208, ack 23, win 4096, options [nop,nop,TS val 929388098 ecr 2384023349], length 182
  9. [[ select ... query ]]
  10. 16:02:09.976467 IP 10.35.215.20.3306 > 10.8.0.6.60541: Flags [P.], seq 23:382, ack 208, win 263, options [nop,nop,TS val 2384023368 ecr 929388098], length 359
  11. [[ def stuff ]]
  12. 16:02:09.976515 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [.], ack 382, win 4084, options [nop,nop,TS val 929388117 ecr 2384023368], length 0
  13. 16:02:09.994032 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [P.], seq 208:223, ack 382, win 4096, options [nop,nop,TS val 929388134 ecr 2384023368], length 15
  14. 16:02:10.014007 IP 10.35.215.20.3306 > 10.8.0.6.60541: Flags [P.], seq 382:1097, ack 223, win 263, options [nop,nop,TS val 2384023377 ecr 929388134], length 715
  15. [[ def stuff ]]
  16. 16:02:10.014051 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [.], ack 1097, win 4073, options [nop,nop,TS val 929388153 ecr 2384023377], length 0
  17. 16:02:10.055030 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [P.], seq 223:234, ack 1097, win 4096, options [nop,nop,TS val 929388193 ecr 2384023377], length 11
  18. commit
  19. 16:02:10.073796 IP 10.35.215.20.3306 > 10.8.0.6.60541: Flags [P.], seq 1097:1108, ack 234, win 263, options [nop,nop,TS val 2384023392 ecr 929388193], length 11
  20. 16:02:10.073888 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [.], ack 1108, win 4095, options [nop,nop,TS val 929388211 ecr 2384023392], length 0
  21. 16:02:10.074081 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [P.], seq 234:255, ack 1108, win 4096, options [nop,nop,TS val 929388211 ecr 2384023392], length 21
  22. SET.autocommit=1
  23. 16:02:10.093776 IP 10.35.215.20.3306 > 10.8.0.6.60541: Flags [P.], seq 1108:1119, ack 255, win 263, options [nop,nop,TS val 2384023398 ecr 929388211], length 11
  24. 16:02:10.093820 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [.], ack 1119, win 4095, options [nop,nop,TS val 929388230 ecr 2384023398], length 0
  25. 16:02:10.095071 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [P.], seq 255:289, ack 1119, win 4096, options [nop,nop,TS val 929388231 ecr 2384023398], length 34
  26. select.@@session.tx_read_only
  27. 16:02:10.113888 IP 10.35.215.20.3306 > 10.8.0.6.60541: Flags [P.], seq 1119:1196, ack 289, win 263, options [nop,nop,TS val 2384023403 ecr 929388231], length 77
  28. def....@@session.tx_read_only..?..
  29. 16:02:10.113944 IP 10.8.0.6.60541 > 10.35.215.20.3306: Flags [.], ack 1196, win 4093, options [nop,nop,TS val 929388248 ecr 2384023403], length 0
Add Comment
Please, Sign In to add comment