2022-04-09-TIL

Today I Learned

DB Lock

  • https://sabarada.tistory.com/121
  • https://www.mysqltutorial.org/mysql-table-locking/
  • https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
  • https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
  • https://www.percona.com/blog/2012/03/27/innodbs-gap-locks/
  • https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
  • https://www.ibm.com/docs/en/ias?topic=indexes-clustered-non-clustered
  • https://www.geeksforgeeks.org/indexing-in-databases-set-1/
  • https://www.toolbox.com/tech/sap/blogs/drawbacks-of-generated-surrogate-keys-041712/
  • https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
  • https://jaeseongdev.github.io/development/2021/06/16/Lock%EC%9D%98-%EC%A2%85%EB%A5%98-(Shared-Lock,-Exclusive-Lock,-Record-Lock,-Gap-Lock,-Next-key-Lock)/

MySQL SELECT FOR UPDATE

  • https://jinhokwon.github.io/mysql/mysql-select-for-update/

트랜잭션 격리수준

  • https://velog.io/@jsj3282/%ED%8A%B8%EB%9E%9C%EC%9E%AD%EC%85%98-%EA%B2%A9%EB%A6%AC-%EC%88%98%EC%A4%80Isolatoin-Level