{"id":1823,"date":"2026-09-12T11:47:05","date_gmt":"2026-09-12T08:47:05","guid":{"rendered":"https:\/\/narhost.com\/destek\/mysql-has-gone-away-hatasi-nasil-cozulur\/"},"modified":"2026-09-12T11:47:05","modified_gmt":"2026-09-12T08:47:05","slug":"mysql-has-gone-away-hatasi-nasil-cozulur","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/mysql-has-gone-away-hatasi-nasil-cozulur\/","title":{"rendered":"MySQL Server Has Gone Away Hatas\u0131 Nas\u0131l \u00c7\u00f6z\u00fcl\u00fcr"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son g\u00f6zden ge\u00e7irme: Eyl\u00fcl 2026 \u00b7 cPanel 136 ve MariaDB 10.11 resmi 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>MySQL server has gone away<\/code> yani <strong>mysql has gone away hatas\u0131<\/strong>, ba\u011flant\u0131 bo\u015fta kal\u0131p zaman a\u015f\u0131m\u0131na (<code>wait_timeout<\/code>) u\u011frad\u0131\u011f\u0131nda ya da g\u00f6nderilen sorgu sunucunun izin verdi\u011fi paket boyutunu (<code>max_allowed_packet<\/code>) a\u015ft\u0131\u011f\u0131nda \u00e7\u0131kar; phpMyAdmin&#8217;den b\u00fcy\u00fck bir dosya i\u00e7e aktar\u0131yorsan\u0131z dosyay\u0131 b\u00f6l\u00fcn, kendi sunucunuzu (VPS\/VDS) y\u00f6netiyorsan\u0131z bu iki de\u011feri <code>my.cnf<\/code>&#8216;te y\u00fckseltip MariaDB&#8217;yi yeniden ba\u015flat\u0131n.<\/p>\n<ol>\n<li>Hangi ortamda \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z\u0131 belirleyin: payla\u015f\u0131ml\u0131 hosting + phpMyAdmin mi, VPS\/VDS + kendi MariaDB&#8217;niz mi.<\/li>\n<li>Payla\u015f\u0131ml\u0131da dosyay\u0131 par\u00e7alara b\u00f6l\u00fcp phpMyAdmin&#8217;den tekrar i\u00e7e aktar\u0131n.<\/li>\n<li>VPS\/VDS&#8217;te <code>wait_timeout<\/code> ve <code>max_allowed_packet<\/code>&#8216;i y\u00fckseltip servisi yeniden ba\u015flat\u0131n.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>cPanel (payla\u015f\u0131ml\u0131) ya da SSH (VPS\/VDS)<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Payla\u015f\u0131ml\u0131 hosting (CloudLinux) ya da VPS\/VDS (kendi MariaDB y\u00f6netimi)<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>cPanel kullan\u0131c\u0131s\u0131 ya da sunucuda root<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/web-hosting\" title=\"Web Hosting paketleri \u2014 Narhost\">Web Hosting<\/a>, <a href=\"https:\/\/narhost.com\/vps-sunucu\" title=\"VPS Sunucu paketleri \u2014 Narhost\">VPS Sunucu<\/a><\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>\u0130\u00e7e aktarmadan \u00f6nce veritaban\u0131n\u0131z\u0131n g\u00fcncel bir yede\u011fini al\u0131n.<\/li>\n<li>Payla\u015f\u0131ml\u0131 hostingteyseniz cPanel kullan\u0131c\u0131 bilgilerinizle phpMyAdmin&#8217;e girebiliyor olmal\u0131s\u0131n\u0131z.<\/li>\n<li>VPS\/VDS&#8217;teyseniz SSH eri\u015fiminiz ve <code>my.cnf<\/code> dosyas\u0131n\u0131n yolunu bilmeniz gerekir; bu sunucu kendi y\u00f6netiminizdedir, Narhost dosyay\u0131 sizin i\u00e7in d\u00fczenlemez.<\/li>\n<\/ul>\n<\/div>\n<h2>MySQL has gone away hatas\u0131 neden olur<\/h2>\n<p><a href=\"https:\/\/mariadb.com\/kb\/en\/mysql-server-has-gone-away\/\" title=\"MariaDB resmi bilgi bankas\u0131 \u2014 MySQL server has gone away a\u00e7\u0131klamas\u0131\" target=\"_blank\" rel=\"noopener\">MariaDB&#8217;nin resmi bilgi bankas\u0131na g\u00f6re<\/a> sunucu, bo\u015fta kalan bir ba\u011flant\u0131y\u0131 belirli bir s\u00fcre (<code>wait_timeout<\/code>) sonunda kendili\u011finden kapat\u0131r; bu s\u00fcrenin a\u015f\u0131lmas\u0131ndan sonra g\u00f6nderilen bir sorgu <code>MySQL server has gone away<\/code> hatas\u0131yla d\u00f6ner. Ayn\u0131 hata, g\u00f6nderilen tek bir sorgu ya da sat\u0131r sunucunun kabul etti\u011fi <code>max_allowed_packet<\/code> boyutundan b\u00fcy\u00fckse de g\u00f6r\u00fcl\u00fcr; phpMyAdmin&#8217;den b\u00fcy\u00fck bir <code>.sql<\/code> dosyas\u0131 i\u00e7e aktar\u0131rken en s\u0131k rastlanan senaryo budur.<\/p>\n<p>Daha nadir bir sebep, sunucudaki bellek yetersizli\u011finde i\u015fletim sisteminin MariaDB s\u00fcrecini sonland\u0131rmas\u0131d\u0131r (OOM kill); bu durumda hata her sorguda de\u011fil, sunucu y\u00fck alt\u0131ndayken tekrarlar.<\/p>\n<h2>Ad\u0131m ad\u0131m mysql server hatas\u0131 \u00e7\u00f6z\u00fcm\u00fc<\/h2>\n<h3>Y\u00f6ntem 1 \u2014 Payla\u015f\u0131ml\u0131 hosting (phpMyAdmin i\u00e7e aktarma)<\/h3>\n<ol class=\"kb-adimlar\">\n<li><strong>cPanel \u2192 Veritabanlar\u0131 \u2192 phpMyAdmin<\/strong>&#8216;i a\u00e7\u0131n ve i\u00e7e aktaraca\u011f\u0131n\u0131z <code>.sql<\/code> dosyas\u0131n\u0131n boyutunu kontrol edin.<br \/>\n<figure class=\"kb-ekran\"><img decoding=\"async\" src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/mysql-has-gone-away-hatasi-nasil-cozulur-adim-1.webp\" alt=\"MySQL has gone away hatas\u0131 veren b\u00fcy\u00fck i\u00e7e aktarmalarda kullan\u0131lan cPanel Veritabanlar\u0131m ve phpMyAdmin eri\u015fim ekran\u0131\" width=\"1200\" height=\"917\" loading=\"lazy\"><figcaption>Veritabanlar\u0131m sayfas\u0131; phpMyAdmin ba\u011flant\u0131s\u0131 buradan a\u00e7\u0131l\u0131r.<\/figcaption><\/figure>\n<\/li>\n<li>Dosya b\u00fcy\u00fckse bir metin d\u00fczenleyiciyle birka\u00e7 par\u00e7aya b\u00f6l\u00fcn; her par\u00e7a \u0130\u00e7e Aktar sekmesinin g\u00f6sterdi\u011fi y\u00fckleme s\u0131n\u0131r\u0131n\u0131n alt\u0131nda olmal\u0131.<br \/>\n<figure class=\"kb-ekran\"><img decoding=\"async\" src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/mysql-has-gone-away-hatasi-nasil-cozulur-adim-2.webp\" alt=\"cPanel phpMyAdmin i\u00e7e aktarma ekran\u0131nda dosya boyutu ve zaman a\u015f\u0131m\u0131 s\u0131n\u0131rlar\u0131n\u0131n g\u00f6r\u00fcld\u00fc\u011f\u00fc b\u00f6l\u00fcm\" width=\"1188\" height=\"715\" loading=\"lazy\"><figcaption>phpMyAdmin \u0130\u00e7e Aktar sekmesi; dosya boyutu s\u0131n\u0131r\u0131 ve k\u0131smi i\u00e7e aktarma se\u00e7ene\u011fi burada g\u00f6r\u00fcn\u00fcr.<\/figcaption><\/figure>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: her par\u00e7a tek ba\u015f\u0131na hatas\u0131z i\u00e7e aktar\u0131l\u0131r.<\/p>\n<\/li>\n<li>Par\u00e7al\u0131 i\u00e7e aktarma da <code>MySQL server has gone away<\/code> veriyorsa sunucu taraf\u0131ndaki <code>wait_timeout<\/code> ya da <code>max_allowed_packet<\/code> de\u011ferinin y\u00fckseltilmesi gerekir; payla\u015f\u0131ml\u0131 hostingde bu ayar m\u00fc\u015fteri taraf\u0131ndan de\u011fi\u015ftirilemez, destek talebi a\u00e7\u0131p dosya boyutunu ve ald\u0131\u011f\u0131n\u0131z tam hatay\u0131 belirtin.<\/li>\n<\/ol>\n<h3>Y\u00f6ntem 2 \u2014 VPS\/VDS (kendi MariaDB y\u00f6netiminiz)<\/h3>\n<div class=\"warn-box\">\n<p class=\"label\">Dikkat<\/p>\n<p>Servisi yeniden ba\u015flatmak o anda MariaDB&#8217;ye ba\u011fl\u0131 t\u00fcm uygulamalar\u0131n ba\u011flant\u0131s\u0131n\u0131 k\u0131sa s\u00fcreli\u011fine keser; i\u015flemi d\u00fc\u015f\u00fck trafikli bir saatte yap\u0131n.<\/p>\n<\/div>\n<ol class=\"kb-adimlar\">\n<li>SSH ile sunucuya ba\u011flan\u0131p <code>\/etc\/mysql\/mariadb.conf.d\/<\/code> ya da <code>\/etc\/my.cnf.d\/<\/code> alt\u0131ndaki yap\u0131land\u0131rma dosyas\u0131n\u0131 a\u00e7\u0131n.<\/li>\n<li><code>[mysqld]<\/code> b\u00f6l\u00fcm\u00fcne <code>wait_timeout=600<\/code> ve <code>max_allowed_packet=256M<\/code> sat\u0131rlar\u0131n\u0131 ekleyin ya da mevcut de\u011ferleri y\u00fckseltin.<\/li>\n<li><code>systemctl restart mariadb<\/code> komutuyla servisi yeniden ba\u015flat\u0131n.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>systemctl status mariadb<\/code> komutu &#8220;active (running)&#8221; durumunu g\u00f6sterir.<\/p>\n<\/li>\n<li>Sunucu y\u00fck alt\u0131nda s\u0131k s\u0131k ayn\u0131 hatay\u0131 veriyorsa <code>journalctl -k<\/code> \u00e7\u0131kt\u0131s\u0131nda &#8220;Out of memory&#8221; sat\u0131r\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol edin; varsa sorun bellek yetersizli\u011fidir.<\/li>\n<\/ol>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Payla\u015f\u0131ml\u0131da i\u00e7e aktarma &#8220;ba\u015far\u0131yla tamamland\u0131&#8221; mesaj\u0131yla bitiyorsa, VPS\/VDS&#8217;te ise uygulaman\u0131z yeniden ba\u011flan\u0131p sorgu \u00e7al\u0131\u015ft\u0131rabiliyorsa mysql has gone away hatas\u0131 giderilmi\u015f demektir. VPS&#8217;te <code>SHOW VARIABLES LIKE 'wait_timeout';<\/code> komutuyla yeni de\u011feri de do\u011frulayabilirsiniz.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00e7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>WordPress ya da ba\u015fka bir uygulama h\u00e2l\u00e2 ba\u011flant\u0131 hatas\u0131 veriyor.<\/strong> Uygulama taraf\u0131ndaki ba\u011flant\u0131 ayarlar\u0131 da kontrol edilmeli; <a href=\"https:\/\/narhost.com\/destek\/wordpress-veritabani-baglantisi-nasil-duzeltilir\/\" title=\"WordPress veritaban\u0131 ba\u011flant\u0131s\u0131 nas\u0131l d\u00fczeltilir \u2014 Narhost Destek\">WordPress veritaban\u0131 ba\u011flant\u0131s\u0131 nas\u0131l d\u00fczeltilir<\/a> yaz\u0131s\u0131na bak\u0131n.<\/li>\n<li><strong>phpMyAdmin&#8217;den d\u0131\u015fa aktar\u0131rken de ayn\u0131 hatay\u0131 al\u0131yorsunuz.<\/strong> B\u00fcy\u00fck d\u0131\u015fa aktarmalarda benzer bir zaman a\u015f\u0131m\u0131 ya\u015fan\u0131r; <a href=\"https:\/\/narhost.com\/destek\/phpmyadmin-export-sorunu-nasil-giderilir\/\" title=\"phpMyAdmin export sorunu nas\u0131l giderilir \u2014 Narhost Destek\">phpMyAdmin export sorunu nas\u0131l giderilir<\/a> yaz\u0131s\u0131ndaki ayarlar\u0131 uygulay\u0131n.<\/li>\n<li><strong>Ba\u011flant\u0131y\u0131 komut sat\u0131r\u0131ndan test etmek istiyorsunuz.<\/strong><a href=\"https:\/\/narhost.com\/destek\/mysql-sunucuya-nasil-baglanilir\/\" title=\"MySQL sunucuya nas\u0131l ba\u011flan\u0131l\u0131r \u2014 Narhost Destek\">MySQL sunucuya nas\u0131l ba\u011flan\u0131l\u0131r<\/a> yaz\u0131s\u0131ndaki komutlarla do\u011frudan ba\u011flant\u0131 kurup sorguyu deneyebilirsiniz.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Payla\u015f\u0131ml\u0131 hostingteyseniz destek talebine dosya boyutunu, ald\u0131\u011f\u0131n\u0131z tam hata sat\u0131r\u0131n\u0131 ve hatan\u0131n i\u00e7e aktarma m\u0131 yoksa uygulama taraf\u0131nda m\u0131 \u00e7\u0131kt\u0131\u011f\u0131n\u0131 ekleyin; sunucu taraf\u0131 bir ayar de\u011fi\u015fikli\u011fi gerekiyorsa bunu ekibimiz yapar.<\/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\/site-bazen-acilmiyorsa-ne-yapilmali\/\" title=\"Site bazen a\u00e7\u0131lm\u0131yorsa ne yap\u0131lmal\u0131 \u2014 Narhost Destek\">Site bazen a\u00e7\u0131lm\u0131yorsa ne yap\u0131lmal\u0131<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/error-establishing-a-database-connection-cozumu\/\" title=\"Error establishing a database connection \u00e7\u00f6z\u00fcm\u00fc \u2014 Narhost Destek\">Error establishing a database connection \u00e7\u00f6z\u00fcm\u00fc<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/phpmyadmin-export-sorunu-nasil-giderilir\/\" title=\"phpMyAdmin export sorunu nas\u0131l giderilir \u2014 Narhost Destek\">phpMyAdmin export sorunu nas\u0131l giderilir<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/mysql-sunucuya-nasil-baglanilir\/\" title=\"MySQL sunucuya nas\u0131l ba\u011flan\u0131l\u0131r \u2014 Narhost Destek\">MySQL sunucuya nas\u0131l ba\u011flan\u0131l\u0131r<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a sorulan sorular<\/h2>\n<h3>wait_timeout de\u011ferini kendim \u00f6\u011frenebilir miyim?<\/h3>\n<p>VPS\/VDS&#8217;te <code>SHOW VARIABLES LIKE 'wait_timeout';<\/code> komutuyla g\u00f6r\u00fcrs\u00fcn\u00fcz; payla\u015f\u0131ml\u0131 hostingde bu de\u011fer sunucu taraf\u0131nda tutulur ve panelden g\u00f6r\u00fcnt\u00fclenmez.<\/p>\n<h3>Neden b\u00fcy\u00fck bir dosyay\u0131 tek seferde i\u00e7e aktaram\u0131yorum?<\/h3>\n<p>phpMyAdmin&#8217;in y\u00fckleme boyutu ve sunucunun paket s\u0131n\u0131r\u0131 belirli bir \u00fcst de\u011ferin \u00fczerine \u00e7\u0131kmaz; dosyay\u0131 b\u00f6lmek ya da komut sat\u0131r\u0131ndan (VPS&#8217;te) i\u00e7e aktarmak bu s\u0131n\u0131r\u0131 a\u015far.<\/p>\n<h3>MariaDB yeniden ba\u015flat\u0131ld\u0131\u011f\u0131nda veri kayb\u0131 olur mu?<\/h3>\n<p>Hay\u0131r, servis yeniden ba\u015flatma yaln\u0131zca \u00e7al\u0131\u015fan s\u00fcreci s\u0131f\u0131rlar; disk \u00fczerindeki tablo verileri de\u011fi\u015fmez. Ba\u011fl\u0131 uygulamalar birka\u00e7 saniyeli\u011fine ba\u011flant\u0131s\u0131n\u0131 kaybeder ve otomatik olarak yeniden dener.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL has gone away hatas\u0131, phpMyAdmin&#8217;de dosyay\u0131 b\u00f6lme ve VPS\/VDS&#8217;te wait_timeout ile max_allowed_packet de\u011ferlerini y\u00fckseltip MariaDB&#8217;yi yeniden ba\u015flatma ile \u00e7\u00f6z\u00fcl\u00fcr.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-1823","post","type-post","status-publish","format-standard","hentry","category-web-hosting"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1823","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=1823"}],"version-history":[{"count":0,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1823\/revisions"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=1823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=1823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=1823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}