Teknoloji Dünyasına Hoşgeldiniz: MYSQL

<div class="content" style="border: 0px; color: #383838; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline; word-wrap: break-word;"><table align="left" class="easy-table easy-table-default " style="border-collapse: collapse; border-spacing: 0px; border: 0px; font-size: 15px; margin: 0px 0px 18px; max-width: 100%; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline; width: 100%px;"><thead style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><th style="border: 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: bottom;">Özellik</th><th style="border: 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: bottom;">InnoDB</th><th style="border: 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: bottom;">MyISAM</th><th style="border: 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: bottom;">Açıklama</th></tr></thead><tbody style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">transaction</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">var</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yok</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">sıralı olarak yaptığınız veritabanı sorgularında, işlemleri geri alma, gibi özellikler sunan bir sistem</td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">fulltext</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yok</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">var</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">kompleks aramalarda çok işe yarayan bir arama yöntemi</td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">foreign key</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">var</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yok</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">diğer tablolardan referans olarak anahtar sütunların alınması</td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">relationship constraints</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">var</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yok</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">diğer tablolardan referansla alınan sütunların yanlış işlemlerde kısıtlama yapması, uyarması vs.</td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">row-level lock</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">var</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yok</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">satırları update,delete gibi işlemlerden koruyabilme özelliği</td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">table-level lock</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">var</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">var</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">tabloyu update,delete gibi işlemlerden koruyabilme özelliği</td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">ram kullanımı</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yüksek</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">düşük</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"></td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">disk footprint</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yüksek</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">düşük</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">çalışırken tablolarınızı daha etkin kullanabilmek için oluşturulan dosyaların boyutu</td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">select,count</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yavaş</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">hızlı</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">bazı sql komutları</td></tr><tr style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">insert,update</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;"><strong style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">hızlı</strong></td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">yavaş</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; line-height: 18px; margin: 0px; outline: 0px; overflow: visible; padding: 8px; vertical-align: top;">bazı sql komutları</td></tr></tbody></table><span id="more-106" style="border: 0px; margin: 0px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"></span><div style="border: 0px; margin-bottom: 20px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;"></div><div style="border: 0px; margin-bottom: 20px; outline: 0px; overflow: visible; padding: 0px; vertical-align: baseline;">Sonuç olarak tabloda daha çok select, count gibi işlevler kullanılacaksa daha az kaynak tüketimi ve daha hızlı sorgulama için MyISAM tercih edilebilir. Diğer durumlarda ise InnoDB daha avantajlı.</div></div>

InnoDB ile MyISAM arasındaki farklar

Özellik InnoDB MyISAM Açıklama transaction var yok sıralı olarak yaptığınız veritabanı sorgularında, işlemleri geri alma, gibi özellikler su...

Devamı »

InnoDB ile MyISAM arasındaki farklar

Mysql Server Load Sorunları ve Çözümleri

Popüler Yayınlar

Blog Arşivi