{"id":139,"date":"2018-05-22T16:38:38","date_gmt":"2018-05-22T13:38:38","guid":{"rendered":"https:\/\/buraksuatgorgun.com.tr\/?p=139"},"modified":"2018-05-22T16:38:38","modified_gmt":"2018-05-22T13:38:38","slug":"mysqlde-yaval-calisan-sorgularin-kontrolu","status":"publish","type":"post","link":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/2018\/05\/22\/mysqlde-yaval-calisan-sorgularin-kontrolu\/","title":{"rendered":"MySQL&#8217;de Yava\u015f \u00c7al\u0131\u015fan Sorgular\u0131n Kontrol\u00fc"},"content":{"rendered":"<h3><a href=\"#Alt-Baslik\">MySQL&#8217;de Yava\u015f \u00c7al\u0131\u015fan Sorgular\u0131n Kontrol\u00fc<\/a><\/h3>\n<p>Selamlar,<\/p>\n<p>MySQL \u00dczerinde yava\u015f \u00e7al\u0131\u015fan sorgular\u0131 tespit edebilmek i\u00e7in bu sorgular\u0131n bir listesini \u00e7\u0131karabilirsiniz.<\/p>\n<p>\u0130\u015flemi uygulamak i\u00e7in;<\/p>\n<p>MySQL&#8217;e giri\u015f yap\u0131n.<\/p>\n<p>S\u0131ras\u0131 ile a\u015fa\u011f\u0131daki komutlar\u0131 uygulay\u0131n;<\/p>\n<p>set @@global.log_queries_not_using_indexes = 1;<br \/>\nset @@global.slow_query_log = 1;<br \/>\nset @@global.slow_query_log_file = \/var\/log\/mysql-slow.log;<br \/>\nset @@global.long_query_time = 0.5;<\/p>\n<p><span style=\"font-size: inherit;\">Ard\u0131ndan bir s\u00fcre sonra;<\/span><\/p>\n<p>\/var\/log\/mysql-slow.log<\/p>\n<p>Dosyas\u0131n\u0131 kontrol ederek yar\u0131m saniyeyi a\u015fan sorgular\u0131 tespit edebilir, bu ba\u011flamda siteniz ve sorgular\u0131n\u0131z \u00fczerinde optimizasyon ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n<p>Bir s\u00fcre sonra bu eklemeyi tekrar normal hale getirmenizi \u00f6neririm, aksi takdirde unutulmas\u0131 halinde uzun d\u00f6nemde gereksiz disk alan\u0131 kullan\u0131m\u0131na sebep olabilir.<\/p>\n<p>Eski haline almak i\u00e7in ise;<\/p>\n<p>MySQL&#8217;e giri\u015f yap\u0131n.<\/p>\n<p>S\u0131ras\u0131 ile a\u015fa\u011f\u0131daki komutlar\u0131 uygulay\u0131n;<\/p>\n<p>set @@global.log_queries_not_using_indexes = default;<br \/>\nset @@global.slow_query_log = default;<br \/>\nset @@global.slow_query_log_file = default;<br \/>\nset @@global.long_query_time = default;<\/p>\n<p>\u0130yi \u00e7al\u0131\u015fmalar dilerim.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL&#8217;de Yava\u015f \u00c7al\u0131\u015fan Sorgular\u0131n Kontrol\u00fc Selamlar, MySQL \u00dczerinde yava\u015f \u00e7al\u0131\u015fan sorgular\u0131 tespit edebilmek i\u00e7in bu sorgular\u0131n bir listesini \u00e7\u0131karabilirsiniz. \u0130\u015flemi uygulamak i\u00e7in; MySQL&#8217;e giri\u015f yap\u0131n. S\u0131ras\u0131 ile a\u015fa\u011f\u0131daki komutlar\u0131 uygulay\u0131n; set @@global.log_queries_not_using_indexes = 1; set @@global.slow_query_log = 1; set @@global.slow_query_log_file = \/var\/log\/mysql-slow.log; set @@global.long_query_time = 0.5; Ard\u0131ndan bir s\u00fcre sonra; \/var\/log\/mysql-slow.log Dosyas\u0131n\u0131 kontrol ederek yar\u0131m [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[44,58,69,77,79,84,94],"class_list":["post-139","post","type-post","status-publish","format-standard","hentry","category-linux","tag-how","tag-mysql","tag-query","tag-slow","tag-sorgu","tag-to","tag-yavas"],"_links":{"self":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/comments?post=139"}],"version-history":[{"count":0,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/139\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/media?parent=139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/categories?post=139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/tags?post=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}