in query가 15개에서 끊기는 이유

안녕하세요 선생님. 좋은 강의 잘 듣고 있습니다.

orderV3_page() 함수를 생성해보고 query를 돌려보다가 문득 궁금증이 생겨 질문 드립니다.

################################시스템 로그 시작###################################

select

order0_.order_id as order_id1_6_0_,

member1_.member_id as member_i1_4_1_,

delivery2_.delivery_id as delivery1_2_2_,

order0_.delivery_id as delivery4_6_0_,

order0_.member_id as member_i5_6_0_,

order0_.order_date as order_da2_6_0_,

order0_.status as status3_6_0_,

member1_.city as city2_4_1_,

member1_.street as street3_4_1_,

member1_.zipcode as zipcode4_4_1_,

member1_.name as name5_4_1_,

delivery2_.city as city2_2_2_,

delivery2_.street as street3_2_2_,

delivery2_.zipcode as zipcode4_2_2_,

delivery2_.status as status5_2_2_

from

orders order0_

inner join

member member1_

on order0_.member_id=member1_.member_id

inner join

delivery delivery2_

on order0_.delivery_id=delivery2_.delivery_id limit ?

2020-03-22 18:52:21.584 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741584 | took 1ms | statement | connection 14| url jdbc:h2:tcp://localhost/~/jpashop

select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id limit ?

2020-03-22 18:52:21.619 DEBUG 22089 --- [nio-8080-exec-2] org.hibernate.SQL :

select

orderitems0_.order_id as order_id5_5_1_,

orderitems0_.order_item_id as order_it1_5_1_,

orderitems0_.order_item_id as order_it1_5_0_,

orderitems0_.count as count2_5_0_,

orderitems0_.item_id as item_id4_5_0_,

orderitems0_.order_id as order_id5_5_0_,

orderitems0_.order_price as order_pr3_5_0_

from

order_item orderitems0_

where

orderitems0_.order_id in (

?, ?, ?, ?, ?, ?, ?, ?, ?, ?

)

2020-03-22 18:52:21.621 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741621 | took 0ms | statement | connection 14| url jdbc:h2:tcp://localhost/~/jpashop

select orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.count as count2_5_0_, orderitems0_.item_id as item_id4_5_0_, orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_price as order_pr3_5_0_ from order_item orderitems0_ where orderitems0_.order_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

2020-03-22 18:52:21.641 DEBUG 22089 --- [nio-8080-exec-2] org.hibernate.SQL :

select

item0_.item_id as item_id2_3_0_,

item0_.name as name3_3_0_,

item0_.price as price4_3_0_,

item0_.stock_quantity as stock_qu5_3_0_,

item0_.author as author6_3_0_,

item0_.isbn as isbn7_3_0_,

item0_.actor as actor8_3_0_,

item0_.director as director9_3_0_,

item0_.artist as artist10_3_0_,

item0_.etc as etc11_3_0_,

item0_.dtype as dtype1_3_0_

from

item item0_

where

item0_.item_id in (

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?

)

2020-03-22 18:52:21.643 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741643 | took 0ms | statement | connection 14| url jdbc:h2:tcp://localhost/~/jpashop

select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.author as author6_3_0_, item0_.isbn as isbn7_3_0_, item0_.actor as actor8_3_0_, item0_.director as director9_3_0_, item0_.artist as artist10_3_0_, item0_.etc as etc11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

2020-03-22 18:52:21.654 DEBUG 22089 --- [nio-8080-exec-2] org.hibernate.SQL :

select

item0_.item_id as item_id2_3_0_,

item0_.name as name3_3_0_,

item0_.price as price4_3_0_,

item0_.stock_quantity as stock_qu5_3_0_,

item0_.author as author6_3_0_,

item0_.isbn as isbn7_3_0_,

item0_.actor as actor8_3_0_,

item0_.director as director9_3_0_,

item0_.artist as artist10_3_0_,

item0_.etc as etc11_3_0_,

item0_.dtype as dtype1_3_0_

from

item item0_

where

item0_.item_id in (

?, ?, ?, ?, ?

)

2020-03-22 18:52:21.656 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741656 | took 0ms | statement | connection 14| url jdbc:h2:tcp://localhost/~/jpashop

위의 로그를 보시면 item에 in query가 15개에서 끊기고, 나머지 5개에 대하여 다시 쿼리를 날려주는데, 원래 이렇게 끊기는게 정상일까요?

################################시스템 로그 끝###################################

여기서 궁금한 점은 실제 쿼리에서는 한번에 20개에 대해서 in query를 날려주는데 (3)

1) p6spy log 찍힐때만 15개 단위로 짤라져서 찍히는건지,

- 이렇게 생각한 이유는

 ```
 "name": "decorator.datasource.flexy-pool.acquiring-strategy.increment-pool.max-overflow-pool-size",
 "type": "java.lang.Integer",
 "sourceType": "com.github.gavlyukovskiy.boot.jdbc.decorator.flexypool.FlexyPoolProperties$AcquiringStrategy$IncrementPool",
 "defaultValue": 15
 ```

라는 옵션을 찾아서 입니다.

2) 아니면 실제로 h2 db에도 쿼리가 2번 쪼개져서 나가는지 궁금합니다.

- 실제로 h2가 전달받는 쿼리를 보고 싶은데 확인할 방법을 찾지 못하였습니다.

3) 아니면 HikariCP 커넥션 풀이 10개가 max라고 알고있는데 이런 커넥션 pool 갯수랑 상관이 있을까요?

- 이렇게 생각한 이유는

2020-03-22 18:52:21.656 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741656 | took 0ms | statement | connection 15| url jdbc:h2:tcp://localhost/~/jpashop

에서 connection 갯수가 15라고 확인을 했어서 입니다.

**결론: 왜 item 쿼리가 16번째에서 쪼개져서 한번 더 보내질까요?

Inflearn Community Q&A