{"id":12654,"date":"2025-01-07T15:21:22","date_gmt":"2025-01-07T12:21:22","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=12654"},"modified":"2025-01-07T15:21:22","modified_gmt":"2025-01-07T12:21:22","slug":"mysql-database-boyutu-nasil-ogrenilir","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-database-boyutu-nasil-ogrenilir\/","title":{"rendered":"MySQL Database Boyutu Nas\u0131l \u00d6\u011frenilir?"},"content":{"rendered":"

E\u011fer MySQL veritaban\u0131n\u0131z\u0131n ne kadar yer kaplad\u0131\u011f\u0131n\u0131 \u00f6\u011frenmek istiyorsan\u0131z bunun i\u00e7in baz\u0131 kolay sorgular var. Depolama alan\u0131n\u0131z\u0131 etkin bir \u015fekilde kullanan b\u00fcy\u00fck tablolar\u0131 tespit etmek i\u00e7in a\u015fa\u011f\u0131daki sorgu y\u00f6ntemlerini uygulayabilirsiniz.<\/p>\n

Veritaban\u0131 Boyutunu Sorgulama (Megabyte (MB) Olarak)<\/h2>\n

MySQL Database boyutunu \u00f6\u011frenmek i\u00e7in a\u015fa\u011f\u0131daki sorgu veritaban\u0131n\u0131z\u0131n toplam boyutunu megabyte cinsinden g\u00f6sterecektir:<\/p>\n

\n
SELECT<\/span>
\nFORMAT(SUM<\/span>(DATA_LENGTH +<\/span> INDEX_LENGTH) \/<\/span> (1024<\/span> *<\/span> 1024<\/span>), 2<\/span>) AS<\/span> \"Boyut (MB)\"
\nFROM<\/span>
\nINFORMATION_SCHEMA.TABLES
\nWHERE<\/span>
\nTABLE_SCHEMA =<\/span> 'VERITABANI_ADI'<\/span>;<\/code><\/div>\n<\/div>\n

\u00d6rnek \u00c7\u0131kt\u0131<\/h3>\n

Boyut (MB)
\n254.87<\/p>\n

Gigabyte (GB) Olarak Boyut Hesaplama<\/h2>\n

E\u011fer veritaban\u0131n\u0131z olduk\u00e7a b\u00fcy\u00fckse ve GB cinsinden g\u00f6rmek isterseniz, \u015fu sorguyu deneyebilirsiniz:<\/p>\n

\n
SELECT<\/span>
\nCONCAT(FORMAT(SUM<\/span>(DATA_LENGTH +<\/span> INDEX_LENGTH) \/<\/span> (1024<\/span> *<\/span> 1024<\/span> *<\/span> 1024<\/span>), 2<\/span>), ' GB'<\/span>) AS<\/span> \"Boyut (GB)\"
\nFROM<\/span>
\nINFORMATION_SCHEMA.TABLES
\nWHERE<\/span>
\nTABLE_SCHEMA =<\/span> 'VERITABANI_ADI'<\/span>;
\n<\/code><\/div>\n<\/div>\n

Bu sorgu sonucu, do\u011frudan gigabyte olarak formatlanm\u0131\u015f \u015fekilde g\u00f6receksiniz.<\/p>\n

\u00d6rnek \u00c7\u0131kt\u0131<\/h3>\n

Boyut (GB)
\n1.45 GB<\/p>\n

Tablolar\u0131n Tek Tek Boyutlar\u0131n\u0131 G\u00f6rme<\/h2>\n

Tablolar\u0131n\u0131z\u0131n hangi boyutlarda oldu\u011funu \u00f6\u011frenmek i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabilirsiniz:<\/p>\n

\n
SELECT<\/span>
\nTABLE_NAME AS<\/span> \"Tablo\",
\nFORMAT(DATA_LENGTH \/<\/span> 1024<\/span> \/<\/span> 1024<\/span>, 2<\/span>) AS<\/span> \"Veri Boyutu (MB)\",
\nFORMAT(INDEX_LENGTH \/<\/span> 1024<\/span> \/<\/span> 1024<\/span>, 2<\/span>) AS<\/span> \"\u0130ndeks Boyutu (MB)\",
\nFORMAT((DATA_LENGTH +<\/span> INDEX_LENGTH) \/<\/span> 1024<\/span> \/<\/span> 1024<\/span>, 2<\/span>) AS<\/span> \"Toplam Boyut (MB)\"
\nFROM<\/span>
\nINFORMATION_SCHEMA.TABLES
\nWHERE<\/span>
\nTABLE_SCHEMA =<\/span> 'VERITABANI_ADI'<\/span>
\nORDER<\/span> BY<\/span>
\n(DATA_LENGTH +<\/span> INDEX_LENGTH) DESC<\/span>;
\n<\/code><\/div>\n<\/div>\n

\u00d6rnek \u00c7\u0131kt\u0131:<\/h4>\n\n\n\n\n\n\n
Tablo<\/th>\nVeri Boyutu (MB)<\/th>\n\u0130ndeks Boyutu (MB)<\/th>\nToplam Boyut (MB)<\/th>\n<\/tr>\n<\/thead>\n
logs<\/td>\n120.56<\/td>\n15.32<\/td>\n135.88<\/td>\n<\/tr>\n
users<\/td>\n98.45<\/td>\n12.30<\/td>\n110.75<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"Windows Hosting<\/a> hizmeti ile projelerinizi aktif hale getirin.<\/p>\n

Ekstra Notlar<\/h2>\n
    \n
  1. Veritaban\u0131 ad\u0131n\u0131 VERITABANI_ADI<\/strong> k\u0131sm\u0131na yazmay\u0131 unutmay\u0131n.<\/li>\n
  2. Tablolar\u0131n boyutunu analiz ederek gereksiz alan kullan\u0131m\u0131n\u0131 tespit edebilir ve tablolar\u0131 optimize edebilirsiniz.<\/li>\n
  3. \u0130ndeksleriniz gere\u011finden fazla b\u00fcy\u00fcd\u00fcyse indeks optimizasyonu yapman\u0131z\u0131 kesinlikle tavsiye ederiz.<\/li>\n<\/ol>\n

    Daha fazla faydal\u0131 bilgi i\u00e7in blog sayfam\u0131z\u0131 ziyaret etmeyi unutmay\u0131n!<\/p>\n","protected":false},"excerpt":{"rendered":"

    E\u011fer MySQL veritaban\u0131n\u0131z\u0131n ne kadar yer kaplad\u0131\u011f\u0131n\u0131 \u00f6\u011frenmek istiyorsan\u0131z bunun i\u00e7in baz\u0131 kolay sorgular var. Depolama alan\u0131n\u0131z\u0131 etkin bir \u015fekilde kullanan b\u00fcy\u00fck tablolar\u0131 tespit etmek i\u00e7in a\u015fa\u011f\u0131daki sorgu y\u00f6ntemlerini uygulayabilirsiniz. Veritaban\u0131 Boyutunu Sorgulama (Megabyte (MB)...<\/p>\n","protected":false},"author":2,"featured_media":12658,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-12654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlserver"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/12654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=12654"}],"version-history":[{"count":5,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/12654\/revisions"}],"predecessor-version":[{"id":12661,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/12654\/revisions\/12661"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/12658"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=12654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=12654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=12654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}