{"id":2479,"date":"2026-10-05T10:00:00","date_gmt":"2026-10-05T07:00:00","guid":{"rendered":"https:\/\/narhost.com\/destek\/?p=2479"},"modified":"2026-10-05T10:00:00","modified_gmt":"2026-10-05T07:00:00","slug":"mysql-too-many-connections-hatasi","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/mysql-too-many-connections-hatasi\/","title":{"rendered":"MySQL Too Many Connections Hatas\u0131 Nas\u0131l \u00c7\u00f6z\u00fcl\u00fcr"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son g\u00f6zden ge\u00e7irme: Eyl\u00fcl 2026 \u00b7 MariaDB 10.11 ve MySQL 8.0 resm\u00ee dok\u00fcman\u0131na g\u00f6re<\/p>\n<div id=\"hizli-cozum\" class=\"ai-box ai-box--cozum\">\n<p class=\"ai-box-title\">H\u0131zl\u0131 \u00e7\u00f6z\u00fcm<\/p>\n<p><code>ERROR 1040 (HY000): Too many connections<\/code> \u2014 <strong>MySQL too many connections<\/strong> hatas\u0131, veritaban\u0131 sunucusundaki e\u015f zamanl\u0131 ba\u011flant\u0131 say\u0131s\u0131n\u0131n <code>max_connections<\/code> s\u0131n\u0131r\u0131na dayand\u0131\u011f\u0131n\u0131 g\u00f6sterir. \u00d6nce ba\u011flant\u0131lar\u0131 neyin tuttu\u011funu bulun, s\u0131n\u0131r\u0131 ancak sonra ve belle\u011fe g\u00f6re y\u00fckseltin.<\/p>\n<ol>\n<li>Payla\u015f\u0131ml\u0131 hostingdeyseniz uygulaman\u0131zdaki kal\u0131c\u0131 ba\u011flant\u0131lar\u0131 kapat\u0131n ve destek talebi a\u00e7\u0131n; sunucu ayar\u0131 sizde de\u011fildir.<\/li>\n<li>VPS\/VDS&#8217;te <code>sudo mysql<\/code> ile girip <code>SHOW FULL PROCESSLIST;<\/code> \u00e7al\u0131\u015ft\u0131r\u0131n.<\/li>\n<li><code>Sleep<\/code> durumunda bekleyen ba\u011flant\u0131lar \u00e7oksa <code>wait_timeout<\/code> de\u011ferini d\u00fc\u015f\u00fcr\u00fcn.<\/li>\n<li>Ger\u00e7ek y\u00fck artm\u0131\u015fsa <code>max_connections<\/code> de\u011ferini bellek hesab\u0131yla y\u00fckseltin.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>cPanel (payla\u015f\u0131ml\u0131, yaln\u0131z uygulama taraf\u0131) \u00b7 VPS\/VDS&#8217;te panel yok<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>MariaDB 10.11 \/ MySQL 8.0, Ubuntu 22.04\/24.04, AlmaLinux 8\/9<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>Payla\u015f\u0131ml\u0131da cPanel kullan\u0131c\u0131s\u0131 \u00b7 VPS\/VDS&#8217;te root ya da sudo<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/vps-sunucu\" title=\"Narhost VPS Sunucu paketleri\">VPS Sunucu<\/a>, VDS Sunucu<\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>Hatan\u0131n tam metnini ve saatini not edin; PHP uygulamalar\u0131nda <code>SQLSTATE[08004] [1040] Too many connections<\/code> bi\u00e7iminde g\u00f6r\u00fcn\u00fcr.<\/li>\n<li>VPS\/VDS&#8217;te yap\u0131land\u0131rma dosyas\u0131n\u0131 de\u011fi\u015ftirmeden \u00f6nce yede\u011fini al\u0131n.<\/li>\n<li>Sunucunun toplam RAM miktar\u0131n\u0131 <code>free -h<\/code> ile \u00f6\u011frenin; s\u0131n\u0131r hesab\u0131 buna g\u00f6re yap\u0131lacak.<\/li>\n<\/ul>\n<\/div>\n<h2>MySQL Too Many Connections Hatas\u0131 Neden Olur<\/h2>\n<p>Her istemci ba\u011flant\u0131s\u0131 sunucuda bir i\u015f par\u00e7ac\u0131\u011f\u0131 ve kendi arabellekleri demektir. S\u0131n\u0131r dolunca yeni ba\u011flant\u0131lar reddedilir, site &#8220;Error establishing a database connection&#8221; benzeri bir sayfa g\u00f6sterir. MariaDB&#8217;de varsay\u0131lan s\u0131n\u0131r 151&#8217;dir ve <code>SUPER<\/code> ya da <code>CONNECTION ADMIN<\/code> yetkili kullan\u0131c\u0131 i\u00e7in bir ba\u011flant\u0131 ayr\u0131l\u0131r; bu y\u00fczden hata s\u0131ras\u0131nda bile root ile i\u00e7eri girebilirsiniz. Ayr\u0131nt\u0131 <a href=\"https:\/\/mariadb.com\/docs\/server\/server-management\/variables-and-modes\/server-system-variables\" title=\"MariaDB Server System Variables \u2014 max_connections ve wait_timeout resm\u00ee dok\u00fcman\u0131\" target=\"_blank\" rel=\"noopener\">MariaDB sistem de\u011fi\u015fkenleri dok\u00fcman\u0131nda<\/a>.<\/p>\n<p>S\u0131k g\u00f6r\u00fclen nedenler: sorgusu bitmi\u015f ama kapat\u0131lmam\u0131\u015f ba\u011flant\u0131lar (<code>Sleep<\/code>), PHP&#8217;de kal\u0131c\u0131 ba\u011flant\u0131 (<code>pconnect<\/code>) kullanan eklentiler, \u00fcst \u00fcste binen cron g\u00f6revleri, kilitlenen bir tablo y\u00fcz\u00fcnden birikip bekleyen sorgular ve bot trafi\u011fi. S\u0131n\u0131r\u0131 y\u00fckseltmek bu durumlar\u0131n \u00e7o\u011funda sorunu yaln\u0131z erteler.<\/p>\n<h2>Ad\u0131m Ad\u0131m \u00c7\u00f6z\u00fcm<\/h2>\n<h3>Y\u00f6ntem 1 \u2014 Payla\u015f\u0131ml\u0131 hosting<\/h3>\n<ol class=\"kb-adimlar\">\n<li><strong>Uygulaman\u0131n ba\u011flant\u0131 davran\u0131\u015f\u0131n\u0131 d\u00fczeltin.<\/strong> Veritaban\u0131 ayarlar\u0131nda kal\u0131c\u0131 ba\u011flant\u0131y\u0131 kapat\u0131n, eklentileri tek tek devre d\u0131\u015f\u0131 b\u0131rakarak hatay\u0131 tetikleyeni bulun.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: trafik zirvesinde hata seyrekle\u015fir.<\/p>\n<\/li>\n<li><strong>Kaynak s\u0131n\u0131rlar\u0131na bak\u0131n.<\/strong> E\u015f zamanl\u0131 i\u015flem say\u0131s\u0131 doldu\u011funda ba\u011flant\u0131lar da birikir; <a href=\"https:\/\/narhost.com\/destek\/cloudlinux-lve-kaynak-siniri-nasil-gorulur\/\" title=\"CloudLinux LVE CPU\/RAM\/EP Kullan\u0131m S\u0131n\u0131r\u0131 Nas\u0131l G\u00f6r\u00fcl\u00fcr (cPanel) \u2014 Narhost Destek\">CloudLinux LVE s\u0131n\u0131rlar\u0131n\u0131<\/a> cPanel&#8217;den kontrol edin.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: EP ya da CPU grafi\u011finde hatan\u0131n saatine denk gelen bir s\u0131n\u0131r a\u015f\u0131m\u0131 g\u00f6r\u00fcrseniz neden budur.<\/p>\n<\/li>\n<li><strong>Destek talebi a\u00e7\u0131n.<\/strong> Sunucu genelindeki <code>max_connections<\/code> de\u011feri m\u00fc\u015fteri taraf\u0131ndan de\u011fi\u015ftirilemez; hata metnini ve saatini talebe yaz\u0131n.<\/li>\n<\/ol>\n<h3>Y\u00f6ntem 2 \u2014 VPS\/VDS (root)<\/h3>\n<ol class=\"kb-adimlar\">\n<li><strong>Mevcut durumu \u00f6l\u00e7\u00fcn:<\/strong>\n<pre><code class=\"language-bash\">sudo mysql -e \"SHOW VARIABLES LIKE 'max_connections';\"\nsudo mysql -e \"SHOW GLOBAL STATUS LIKE 'Max_used_connections';\"\nsudo mysql -e \"SHOW FULL PROCESSLIST;\"<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>Max_used_connections<\/code> s\u0131n\u0131ra e\u015fitse s\u0131n\u0131r ger\u00e7ekten dolmu\u015ftur. \u0130\u015flem listesinde <code>Command<\/code> s\u00fctunu \u00e7o\u011funlukla <code>Sleep<\/code> ise sorun kapat\u0131lmayan ba\u011flant\u0131lard\u0131r; <code>Query<\/code> ve uzun <code>Time<\/code> de\u011ferleri ise yava\u015f sorgulara i\u015faret eder.<\/p>\n<\/li>\n<li><strong>Tak\u0131lan bir sorguyu sonland\u0131r\u0131n:<\/strong>\n<pre><code class=\"language-bash\">sudo mysql -e \"KILL 1234;\"<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>1234<\/code> yerine i\u015flem listesindeki <code>Id<\/code> de\u011ferini yaz\u0131n; ba\u011flant\u0131 kapan\u0131r.<\/p>\n<\/li>\n<li><strong>Bo\u015fta bekleyen ba\u011flant\u0131lar\u0131 k\u0131salt\u0131n ve s\u0131n\u0131r\u0131 ayarlay\u0131n.<\/strong> Ubuntu&#8217;da MariaDB i\u00e7in <code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code>, MySQL i\u00e7in <code>\/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code> dosyas\u0131n\u0131n <code>[mysqld]<\/code> b\u00f6l\u00fcm\u00fcne yaz\u0131n:\n<pre><code class=\"language-ini\">[mysqld]\nmax_connections = 300\nwait_timeout = 300<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>sudo systemctl restart mariadb<\/code> (MySQL&#8217;de <code>mysql<\/code>) sonras\u0131 yeni de\u011ferler ge\u00e7erli olur.<\/p>\n<\/li>\n<\/ol>\n<div class=\"warn-box\">\n<p class=\"label\">Dikkat<\/p>\n<p>S\u0131n\u0131r\u0131 bellek hesab\u0131 yapmadan y\u00fckseltmeyin. Kaba \u00f6l\u00e7\u00fc: <code>innodb_buffer_pool_size<\/code> + ba\u011flant\u0131 say\u0131s\u0131 \u00d7 (sort, join, read arabellekleri + i\u015f par\u00e7ac\u0131\u011f\u0131 y\u0131\u011f\u0131n\u0131). Toplam RAM&#8217;i a\u015farsa \u00e7ekirdek veritaban\u0131 s\u00fcrecini sonland\u0131r\u0131r ve hata daha a\u011f\u0131r h\u00e2le gelir.<\/p>\n<\/div>\n<figure class=\"nh-sema\"><img src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/mysql-too-many-connections-hatasi-sema-narhost.webp\" alt=\"MySQL too many connections hatas\u0131 te\u015fhis \u015femas\u0131 \u2014 i\u015flem listesini okuma, bo\u015fta bekleyen ba\u011flant\u0131lar\u0131 k\u0131saltma, s\u0131n\u0131r\u0131 bellek hesab\u0131yla y\u00fckseltme\" width=\"1200\" height=\"500\" loading=\"lazy\" decoding=\"async\"><figcaption>\u00d6nce ba\u011flant\u0131lar\u0131 tutan\u0131 bulun, s\u0131n\u0131r\u0131 en son ve belle\u011fe g\u00f6re art\u0131r\u0131n.<\/figcaption><\/figure>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p><code>SHOW VARIABLES LIKE 'max_connections';<\/code> yeni de\u011feri g\u00f6steriyor ve yo\u011fun saatlerde <code>Max_used_connections<\/code> s\u0131n\u0131r\u0131n belirgin bi\u00e7imde alt\u0131nda kal\u0131yorsa sorun \u00e7\u00f6z\u00fclm\u00fc\u015ft\u00fcr. <code>SHOW GLOBAL STATUS LIKE 'Threads_connected';<\/code> ile anl\u0131k ba\u011flant\u0131 say\u0131s\u0131n\u0131 da izleyebilirsiniz.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00c7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>Ba\u011flant\u0131lar d\u00fc\u015fm\u00fcyor, sorgular uzun s\u00fcr\u00fcyor.<\/strong> Yava\u015f sorgular kuyruk olu\u015fturur; ba\u011flant\u0131 kopmalar\u0131 varsa <a href=\"https:\/\/narhost.com\/destek\/mysql-has-gone-away-hatasi-nasil-cozulur\/\" title=\"MySQL Server Has Gone Away Hatas\u0131 Nas\u0131l \u00c7\u00f6z\u00fcl\u00fcr \u2014 Narhost Destek\">MySQL server has gone away kart\u0131na<\/a> bak\u0131n.<\/li>\n<li><strong>S\u0131n\u0131r\u0131 y\u00fckselttikten sonra veritaban\u0131 kapan\u0131yor.<\/strong> Bellek yetmiyor; <a href=\"https:\/\/narhost.com\/destek\/sistem-bellegi-ram-takibi-nasil-yapilir\/\" title=\"Linux RAM Kullan\u0131m\u0131 Nas\u0131l \u0130zlenir (free, top, htop) \u2014 Narhost Destek\">RAM kullan\u0131m\u0131n\u0131 izleyin<\/a> ve de\u011feri geri \u00e7ekin.<\/li>\n<li><strong>Kurulum varsay\u0131lanlar\u0131ndan \u015f\u00fcpheleniyorsunuz.<\/strong><a href=\"https:\/\/narhost.com\/destek\/mariadb-kurulumu-guvenli-yapilandirma\/\" title=\"MariaDB Kurulumu ve G\u00fcvenli Yap\u0131land\u0131rma (Ubuntu VPS) \u2014 Narhost Destek\">MariaDB g\u00fcvenli yap\u0131land\u0131rma kart\u0131ndaki<\/a> ayarlar\u0131 g\u00f6zden ge\u00e7irin.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Talebe \u015funlar\u0131 ekleyin: alan ad\u0131 ya da sunucu IP adresi, hatan\u0131n birebir metni ve saati, VPS&#8217;teyseniz <code>SHOW FULL PROCESSLIST<\/code> \u00e7\u0131kt\u0131s\u0131. Payla\u015f\u0131ml\u0131 hostingte sunucu taraf\u0131n\u0131 biz inceleriz. Y\u00fck s\u00fcrekli art\u0131yorsa <a href=\"https:\/\/narhost.com\/blog\/paylasimli-hostingden-vpse-ne-zaman-gecilir\/\" title=\"Payla\u015f\u0131ml\u0131 Hostingden VPS&#039;e Ne Zaman Ge\u00e7ilir \u2014 Narhost Blog\">payla\u015f\u0131ml\u0131 hostingden VPS&#8217;e ge\u00e7i\u015f<\/a> yaz\u0131s\u0131 karar vermenize yard\u0131m eder.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\" title=\"Narhost destek talebi a\u00e7\">Destek talebi a\u00e7<\/a><\/div>\n<div class=\"kb-ilgili\">\n<p class=\"label\">Sonraki ad\u0131mlar<\/p>\n<ul>\n<li><a href=\"https:\/\/narhost.com\/destek\/vps-vds-ilk-kurulum-rehberi\/\" title=\"VPS VDS Sunucu \u0130lk Kurulum Rehberi (10 Ad\u0131mda G\u00fcvenli Kurulum) \u2014 Narhost Destek\">VPS VDS ilk kurulum rehberi<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/mysql-has-gone-away-hatasi-nasil-cozulur\/\" title=\"MySQL Server Has Gone Away Hatas\u0131 Nas\u0131l \u00c7\u00f6z\u00fcl\u00fcr \u2014 Narhost Destek\">MySQL server has gone away hatas\u0131<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/mariadb-kurulumu-guvenli-yapilandirma\/\" title=\"MariaDB Kurulumu ve G\u00fcvenli Yap\u0131land\u0131rma (Ubuntu VPS) \u2014 Narhost Destek\">MariaDB kurulumu ve g\u00fcvenli yap\u0131land\u0131rma<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a sorulan sorular<\/h2>\n<h3>MySQL too many connections hatas\u0131nda root ile de giremezsem ne yapmal\u0131y\u0131m?<\/h3>\n<p>Ayr\u0131lan tek ba\u011flant\u0131y\u0131 ba\u015fka bir yetkili oturum kullan\u0131yor olabilir. Web sunucusunu ya da PHP-FPM&#8217;i k\u0131sa s\u00fcreli\u011fine durdurup ba\u011flant\u0131lar\u0131n d\u00fc\u015fmesini bekleyin, sonra <code>sudo mysql<\/code> ile girin.<\/p>\n<h3>max_connections de\u011ferini yeniden ba\u015flatmadan de\u011fi\u015ftirebilir miyim?<\/h3>\n<p>Evet, <code>SET GLOBAL max_connections = 300;<\/code> an\u0131nda uygulan\u0131r ama yeniden ba\u015flatmada kaybolur. Kal\u0131c\u0131 olmas\u0131 i\u00e7in de\u011feri yap\u0131land\u0131rma dosyas\u0131na da yaz\u0131n.<\/p>\n<h3>max_user_connections hatas\u0131 ayn\u0131 \u015fey mi?<\/h3>\n<p>Hay\u0131r. O hata sunucu genelindeki de\u011fil, tek bir veritaban\u0131 kullan\u0131c\u0131s\u0131na tan\u0131nan s\u0131n\u0131r\u0131n doldu\u011funu g\u00f6sterir; payla\u015f\u0131ml\u0131 hostingte bu s\u0131n\u0131r i\u00e7in de destek talebi a\u00e7\u0131l\u0131r.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>ERROR 1040 Too many connections hatas\u0131n\u0131n nedenleri ve \u00e7\u00f6z\u00fcm\u00fc: payla\u015f\u0131ml\u0131 hostingte kal\u0131c\u0131 ba\u011flant\u0131lar, LVE s\u0131n\u0131rlar\u0131 ve destek talebi; VPS\/VDS&#8217;te SHOW FULL PROCESSLIST, KILL, wait_timeout, max_connections ve bellek hesab\u0131.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[173],"class_list":["post-2479","post","type-post","status-publish","format-standard","hentry","category-vps-server","tag-mariadb"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/comments?post=2479"}],"version-history":[{"count":1,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2479\/revisions"}],"predecessor-version":[{"id":2856,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/2479\/revisions\/2856"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=2479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=2479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=2479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}