{"id":37,"date":"2026-09-28T17:32:00","date_gmt":"2026-09-28T17:32:00","guid":{"rendered":"https:\/\/www.akifsen.com.tr\/blog\/2026\/09\/28\/database-connection-pool-sizing\/"},"modified":"2026-09-28T17:32:00","modified_gmt":"2026-09-28T17:32:00","slug":"database-connection-pool-sizing","status":"publish","type":"post","link":"https:\/\/www.akifsen.com.tr\/blog\/2026\/09\/28\/database-connection-pool-sizing\/","title":{"rendered":"Connection Pool&#8217;u B\u00fcy\u00fctmek Veritaban\u0131n\u0131 H\u0131zland\u0131rmaz"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Production&#8217;da \u015fu hatay\u0131 g\u00f6rd\u00fc\u011f\u00fcn\u00fcz\u00fc d\u00fc\u015f\u00fcn\u00fcn:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Connection is not available,\nrequest timed out after 30000ms<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">En do\u011fal tepki \u015fudur: pool k\u00fc\u00e7\u00fck kalm\u0131\u015f, b\u00fcy\u00fctelim.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>spring.datasource.hikari.maximum-pool-size=100<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Deploy edersiniz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Birka\u00e7 g\u00fcn sonra ayn\u0131 hata geri gelir. \u00dcstelik bu sefer veritaban\u0131 CPU&#8217;su da y\u00fcksektir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Veritaban\u0131 sonsuz paralel \u00e7al\u0131\u015fmaz<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bir veritaban\u0131 sunucusunun belirli say\u0131da CPU core&#8217;u ve disk kapasitesi vard\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">8 core&#8217;lu bir makinede ayn\u0131 anda 200 sorgu aktif oldu\u011funda bu sorgular ger\u00e7ekten paralel \u00e7al\u0131\u015fmaz. \u0130\u015fletim sistemi onlar\u0131 s\u0131rayla \u00e7al\u0131\u015ft\u0131r\u0131r, aralar\u0131nda context switch yapar, lock&#8217;lar i\u00e7in bekletir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bir noktadan sonra eklenen her connection toplam throughput&#8217;u art\u0131rmaz. Tam tersine, bekleme ve \u00e7ak\u0131\u015fma maliyetini art\u0131r\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">HikariCP&#8217;nin pool sizing \u00fczerine yazd\u0131\u011f\u0131 not bu y\u00fczden \u00e7ok bilinir. Oradaki temel fikir \u015fu: k\u00fc\u00e7\u00fck bir pool ve \u00f6n\u00fcnde bekleyen bir kuyruk, b\u00fcy\u00fck bir pool&#8217;dan genellikle daha iyi performans verir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ba\u015flang\u0131\u00e7 noktas\u0131 olarak verilen form\u00fcl de olduk\u00e7a m\u00fctevaz\u0131d\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>connections = (core_count * 2) + effective_spindle_count<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu form\u00fcl kesin bir kural de\u011fil. Ama 8 core&#8217;lu bir PostgreSQL i\u00e7in 100 connection&#8217;\u0131n neden \u015f\u00fcpheli oldu\u011funu anlatmaya yeter.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">As\u0131l hesap instance say\u0131s\u0131yla yap\u0131l\u0131r<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pool boyutu tek uygulama i\u00e7in d\u00fc\u015f\u00fcn\u00fcld\u00fc\u011f\u00fcnde makul g\u00f6r\u00fcnebilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ama uygulama tek ba\u015f\u0131na \u00e7al\u0131\u015fm\u0131yor.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>4 instance \u00d7 50 connection = 200<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Autoscaling devreye girip instance say\u0131s\u0131 8&#8217;e \u00e7\u0131kt\u0131\u011f\u0131nda bu say\u0131 400 olur. PostgreSQL&#8217;in varsay\u0131lan <code>max_connections<\/code> de\u011feri ise 100&#8217;d\u00fcr.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Y\u00fck artt\u0131\u011f\u0131nda sistem \u00f6l\u00e7eklenmeye \u00e7al\u0131\u015f\u0131r, yeni instance&#8217;lar connection a\u00e7amaz ve hata vermeye ba\u015flar. Kapasite eklemek sistemi daha k\u0131r\u0131lgan hale getirir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu y\u00fczden pool boyutunu belirlerken soru &#8220;bu uygulamaya ka\u00e7 connection laz\u0131m?&#8221; de\u011fil, &#8220;veritaban\u0131 toplamda ka\u00e7 aktif sorguyu verimli \u00e7al\u0131\u015ft\u0131rabilir ve bunu instance&#8217;lar aras\u0131nda nas\u0131l payla\u015ft\u0131r\u0131r\u0131z?&#8221; olmal\u0131d\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c7ok say\u0131da instance varsa PgBouncer gibi bir connection pooler araya girer. Uygulamalar binlerce hafif connection a\u00e7abilir, veritaban\u0131na ise s\u0131n\u0131rl\u0131 say\u0131da ger\u00e7ek connection gider.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Timeout genellikle semptomdur<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pool&#8217;dan connection alamamak \u00e7o\u011fu zaman pool&#8217;un k\u00fc\u00e7\u00fck oldu\u011funu g\u00f6stermez.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Connection&#8217;lar\u0131n uzun s\u00fcre geri verilmedi\u011fini g\u00f6sterir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En s\u0131k g\u00f6rd\u00fc\u011f\u00fcm sebepler:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Transaction i\u00e7inde HTTP \u00e7a\u011fr\u0131s\u0131 yapmak<\/li>\n\n\n<li>Yava\u015f bir sorgunun index olmadan full scan yapmas\u0131<\/li>\n\n\n<li><code>@Transactional<\/code> metodun gere\u011finden b\u00fcy\u00fck bir i\u015f kapsamas\u0131<\/li>\n\n\n<li>Connection leak, yani kapat\u0131lmayan connection<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Bir transaction&#8217;\u0131n i\u00e7inde 3 saniyelik bir \u00f6deme servisi \u00e7a\u011fr\u0131s\u0131 varsa, o connection 3 saniye boyunca hi\u00e7bir \u015fey yapmadan bekler. Pool&#8217;u ikiye katlamak bu problemi \u00e7\u00f6zmez, sadece biraz erteler.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00d6nce \u00f6l\u00e7mek<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">HikariCP metriklerinde bak\u0131lmas\u0131 gereken birka\u00e7 de\u011fer var:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>hikaricp_connections_active\nhikaricp_connections_pending\nhikaricp_connections_usage_seconds\nhikaricp_connections_acquire_seconds<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><code>usage<\/code> s\u00fcresi uzunsa sorun connection&#8217;\u0131 tutan koddad\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>pending<\/code> s\u00fcrekli y\u00fcksekse ve <code>usage<\/code> k\u0131saysa, ger\u00e7ekten daha fazla connection gerekebilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Leak \u015f\u00fcphesi varsa <code>leakDetectionThreshold<\/code> ge\u00e7ici olarak a\u00e7\u0131labilir. Belirtilen s\u00fcreden uzun tutulan connection&#8217;lar i\u00e7in stack trace loglan\u0131r ve su\u00e7lu genellikle hemen bulunur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pool boyutu bir performans ayar\u0131 gibi g\u00f6r\u00fcnse de asl\u0131nda bir kapasite karar\u0131d\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ve kapasite kararlar\u0131 tek bir servisin konfig\u00fcrasyon dosyas\u0131nda de\u011fil, sistemin b\u00fct\u00fcn\u00fcne bak\u0131larak verilmelidir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pool timeout hatas\u0131 g\u00f6r\u00fcnce ilk refleks pool&#8217;u b\u00fcy\u00fctmek oluyor. Oysa bu \u00e7o\u011fu zaman veritaban\u0131n\u0131 daha da yava\u015flat\u0131yor. Do\u011fru pool boyutu nas\u0131l d\u00fc\u015f\u00fcn\u00fcl\u00fcr?<\/p>\n","protected":false},"author":1,"featured_media":36,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-37","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-veritabani"],"_links":{"self":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts\/37","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=37"}],"version-history":[{"count":0,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts\/37\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/media\/36"}],"wp:attachment":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}