2023-08-07-TIL

Today I Learned

Self-Invocation and Spring AOP with @Transactional

  • https://gmoon92.github.io/spring/aop/2019/04/01/spring-aop-mechanism-with-self-invocation.html
  • https://stir.tistory.com/175
  • https://woodcock.tistory.com/30

Redis DB and @Transactional?

Redis에 커맨드를 날리는 SET과 같은 연산이 Spring의 @Transactioal 영향을 받을까? 영향을 받지 않는다.

  • https://www.vinsguru.com/redis-transaction-with-spring-boot/
  • https://stackoverflow.com/questions/66981818/how-to-configure-transactional-support-to-redis-in-springboot
  • https://velog.io/@cmsskkk/redis-transaction-spring-and-lua-pipeline

Redis Log

Redis에 실행된 커맨드를 조회하려면? 로그파일을 뒤져보거나 monitor 명령어로 실행된 명령어 및 처리내역을 상세하게 볼 수도 있다. 하지만 monitor 명령어는 종료하지 않으면 부하를 줄 수 있으므로 자제하는 것이 좋다.

  • https://redis.com/ebook/part-2-core-concepts/chapter-5-using-redis-for-application-support/5-1-logging-to-redis/
  • https://betterstack.com/community/guides/logging/how-to-start-logging-with-redis/
  • https://linuxhint.com/reading-redis-logs/

조심해야할 Redis 명령어

keys, monitor…

Isolation Level

  • https://brunch.co.kr/@purpledev/4

Lock wait timeout exceeded

  • https://kapentaz.github.io/mysql/Lock-wait-timeout-exceeded;-try-restarting-transaction-%EB%B0%9C%EC%83%9D-%EC%9D%B4%EC%9C%A0%EC%99%80-%ED%95%B4%EA%B2%B0/#
  • https://www.popit.kr/mysql-lock-%EC%83%81%ED%99%A9-%EB%AC%B8%EC%A0%9C-%ED%95%B4%EA%B2%B0/