SHARE
TWEET

Read Only Hibernate Transaction Tcpdump

dig090 Jan 14th, 2016 (edited) 189 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
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
Top