<\/span><\/h2>\nMySQL slow query log, belirli e\u015fik \u00fczerinde \u00e7al\u0131\u015fan sorgular\u0131 kaydeder. \u00dcretim ortam\u0131nda log a\u00e7\u0131l\u0131rken e\u015fik, dosya boyutu ve saklama s\u00fcresi dikkatle ayarlanmal\u0131d\u0131r. \u00c7ok d\u00fc\u015f\u00fck e\u015fik y\u00fcksek disk kullan\u0131m\u0131 ve b\u00fcy\u00fck loglar olu\u015fturabilir. K\u0131sa s\u00fcreli g\u00f6zlemle ba\u015flamak ve yo\u011funlu\u011fa g\u00f6re ayarlamak daha g\u00fcvenlidir.<\/p>\n
Bir sorguyu incelerken yaln\u0131z toplam s\u00fcreye de\u011fil ka\u00e7 kez \u00e7al\u0131\u015ft\u0131\u011f\u0131na da bak\u0131n. Be\u015f saniye s\u00fcren fakat g\u00fcnde bir kez \u00e7al\u0131\u015fan rapor ile 100 milisaniye s\u00fcr\u00fcp saniyede y\u00fcz kez tekrarlanan sorgunun sistem etkisi farkl\u0131d\u0131r. Toplam veritaban\u0131 zaman\u0131n\u0131 en \u00e7ok t\u00fcketen sorgular \u00f6nceliklendirilmelidir.<\/p>\n
EXPLAIN<\/code> \u00e7\u0131kt\u0131s\u0131, sorgunun tablolar\u0131 hangi s\u0131rayla okudu\u011funu, hangi indeksi kulland\u0131\u011f\u0131n\u0131 ve tahmini sat\u0131r say\u0131s\u0131n\u0131 g\u00f6sterir. Tam tablo taramas\u0131 her zaman hata de\u011fildir; k\u00fc\u00e7\u00fck tabloda indeks kullanmak daha pahal\u0131 olabilir. Karar ger\u00e7ek veri da\u011f\u0131l\u0131m\u0131na ve sorgu desenine g\u00f6re verilmelidir.<\/p>\nTahmini plan ile ger\u00e7ek \u00e7al\u0131\u015fma davran\u0131\u015f\u0131 farkl\u0131la\u015fabilir. Desteklenen s\u00fcr\u00fcmlerde ger\u00e7ekle\u015fen sat\u0131r say\u0131s\u0131n\u0131 ve her ad\u0131m\u0131n s\u00fcresini g\u00f6steren analiz se\u00e7enekleri kontroll\u00fc ortamda kullan\u0131labilir. \u00dcretimde a\u011f\u0131r bir sorguyu yaln\u0131z plan g\u00f6rmek i\u00e7in tekrar \u00e7al\u0131\u015ft\u0131rmak ek y\u00fck olu\u015fturabilece\u011finden \u00f6nce sorgunun etkisi ve g\u00fcvenli test zaman\u0131 de\u011ferlendirilmelidir.<\/p>\n