API tools faq
paste
dig090

Read Only Hibernate Transaction Tcpdump

dig090
Jan 14th, 2016
630
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.43 KB | None | 0 0
raw download clone embed print report
  1. 16:06:31.058865 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 3015842094:3015842099, ack 3560784987, win 4096, options [nop,nop,TS val 929646354 ecr 2384085725], length 5
  2. 16:06:31.078573 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 1:12, ack 5, win 249, options [nop,nop,TS val 2384088643 ecr 929646354], length 11
  3. 16:06:31.078622 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 12, win 4095, options [nop,nop,TS val 929646373 ecr 2384088643], length 0
  4. 16:06:31.079182 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 5:43, ack 12, win 4096, options [nop,nop,TS val 929646373 ecr 2384088643], length 38
  5. set.session.transaction.read.only
  6. 16:06:31.098557 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 12:23, ack 43, win 249, options [nop,nop,TS val 2384088648 ecr 929646373], length 11
  7. 16:06:31.098611 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 23, win 4095, options [nop,nop,TS val 929646392 ecr 2384088648], length 0
  8. 16:06:31.098894 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 43:64, ack 23, win 4096, options [nop,nop,TS val 929646392 ecr 2384088648], length 21
  9. SET.autocommit=0
  10. 16:06:31.118488 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 23:34, ack 64, win 249, options [nop,nop,TS val 2384088653 ecr 929646392], length 11
  11. 16:06:31.118533 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 34, win 4095, options [nop,nop,TS val 929646411 ecr 2384088653], length 0
  12. 16:06:31.167842 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 64:246, ack 34, win 4096, options [nop,nop,TS val 929646460 ecr 2384088653], length 182
  13. [[ select stuff ]]
  14. 16:06:31.186025 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 34:393, ack 246, win 263, options [nop,nop,TS val 2384088670 ecr 929646460], length 359
  15. [[ def stuff ]]
  16. 16:06:31.186083 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 393, win 4084, options [nop,nop,TS val 929646477 ecr 2384088670], length 0
  17. 16:06:31.203130 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 246:261, ack 393, win 4096, options [nop,nop,TS val 929646494 ecr 2384088670], length 15
  18. 16:06:31.231153 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 393:1108, ack 261, win 263, options [nop,nop,TS val 2384088679 ecr 929646494], length 715
  19. [[ def stuff ]]
  20. 16:06:31.231213 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 1108, win 4073, options [nop,nop,TS val 929646522 ecr 2384088679], length 0
  21. 16:06:31.267289 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 261:272, ack 1108, win 4096, options [nop,nop,TS val 929646557 ecr 2384088679], length 11
  22. commit
  23. 16:06:31.285950 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 1108:1119, ack 272, win 263, options [nop,nop,TS val 2384088695 ecr 929646557], length 11
  24. 16:06:31.285990 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 1119, win 4095, options [nop,nop,TS val 929646575 ecr 2384088695], length 0
  25. 16:06:31.286209 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 272:293, ack 1119, win 4096, options [nop,nop,TS val 929646575 ecr 2384088695], length 21
  26. SET.autocommit=1
  27. 16:06:31.306017 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 1119:1130, ack 293, win 263, options [nop,nop,TS val 2384088700 ecr 929646575], length 11
  28. 16:06:31.306049 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 1130, win 4095, options [nop,nop,TS val 929646595 ecr 2384088700], length 0
  29. 16:06:31.307578 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 293:327, ack 1130, win 4096, options [nop,nop,TS val 929646596 ecr 2384088700], length 34
  30. select.@@session.tx_read_only
  31. 16:06:31.326036 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 1130:1207, ack 327, win 263, options [nop,nop,TS val 2384088705 ecr 929646596], length 77
  32. def....@@session.tx_read_only..?..
  33. 16:06:31.326085 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 1207, win 4093, options [nop,nop,TS val 929646614 ecr 2384088705], length 0
  34. 16:06:31.326376 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [P.], seq 327:366, ack 1207, win 4096, options [nop,nop,TS val 929646614 ecr 2384088705], length 39
  35. set.session.transaction.read.write
  36. 16:06:31.348532 IP 10.35.215.20.3306 > 10.8.0.6.60570: Flags [P.], seq 1207:1218, ack 366, win 263, options [nop,nop,TS val 2384088710 ecr 929646614], length 11
  37. 16:06:31.348580 IP 10.8.0.6.60570 > 10.35.215.20.3306: Flags [.], ack 1218, win 4095, options [nop,nop,TS val 929646636 ecr 2384088710], length 0
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!