• 22-12-2008, 21:58:26
    #1
    Üyeliği durduruldu
    Alıntı
    Web siteniz sunucu üzerinde sürekli olarak sonlanmayan sql sorguları oluşturmaktadırBu durum sunucu üzerinde performans kayıplarına ve anlık kesintilere neden olmaktadır. Web servisleriniz durdurulmuştur. İlgili problemi incelmeniz ve tarafımıza geri dönüş yapmanız beklenmektedir.

    Problemin nedeni web sitenizde bulunan bir php scriptin sonsuz döngüye girmesi olabilir. Detaylı bilgi aşağıdaki gibidir.

    | 5130 | enbitanem_ | localhost | enbitanem | Query | 679 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5132 | enbitanem_ | localhost | enbitanem | Query | 679 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5145 | enbitanem_ | localhost | enbitanem | Query | 676 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5147 | enbitanem_ | localhost | enbitanem | Query | 675 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5152 | enbitanem_ | localhost | enbitanem | Query | 674 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5180 | enbitanem_ | localhost | enbitanem | Query | 671 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5182 | enbitanem_ | localhost | enbitanem | Query | 670 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5185 | enbitanem_ | localhost | enbitanem | Query | 670 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5191 | enbitanem_ | localhost | enbitanem | Query | 669 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5192 | enbitanem_ | localhost | enbitanem | Query | 669 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5195 | enbitanem_ | localhost | enbitanem | Query | 668 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5209 | enbitanem_ | localhost | enbitanem | Query | 665 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5221 | enbitanem_ | localhost | enbitanem | Query | 663 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5238 | enbitanem_ | localhost | enbitanem | Query | 660 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5280 | enbitanem_ | localhost | enbitanem | Query | 655 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5298 | enbitanem_ | localhost | enbitanem | Query | 653 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5311 | enbitanem_ | localhost | enbitanem | Query | 651 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5334 | enbitanem_ | localhost | enbitanem | Query | 649 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5351 | enbitanem_ | localhost | enbitanem | Query | 647 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5384 | enbitanem_ | localhost | enbitanem | Query | 643 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5389 | enbitanem_ | localhost | enbitanem | Query | 642 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND
    AND session != 'ip |
    | 5395 | enbitanem_ | localhost | enbitanem | Query | 641 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5400 | enbitanem_ | localhost | enbitanem | Query | 641 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5445 | enbitanem_ | localhost | enbitanem | Query | 634 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5454 | enbitanem_ | localhost | enbitanem | Query | 633 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5455 | enbitanem_ | localhost | enbitanem | Query | 633 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5462 | enbitanem_ | localhost | enbitanem | Query | 631 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5464 | enbitanem_ | localhost | enbitanem | Query | 631 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5477 | enbitanem_ | localhost | enbitanem | Query | 628 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5479 | enbitanem_ | localhost | enbitanem | Query | 627 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5488 | enbitanem_ | localhost | enbitanem | Query | 625 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5493 | enbitanem_ | localhost | enbitanem | Query | 623 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5503 | enbitanem_ | localhost | enbitanem | Query | 621 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5505 | enbitanem_ | localhost | enbitanem | Query | 620 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5507 | enbitanem_ | localhost | enbitanem | Query | 620 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5513 | enbitanem_ | localhost | enbitanem | Query | 619 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5516 | enbitanem_ | localhost | enbitanem | Query | 618 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5522 | enbitanem_ | localhost | enbitanem | Query | 617 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5523 | enbitanem_ | localhost | enbitanem | Query | 617 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5529 | enbitanem_ | localhost | enbitanem | Query | 614 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5535 | enbitanem_ | localhost | enbitanem | Query | 612 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5539 | enbitanem_ | localhost | enbitanem | Query | 610 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5542 | enbitanem_ | localhost | enbitanem | Query | 608 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5543 | enbitanem_ | localhost | enbitanem | Query | 608 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5583 | enbitanem_ | localhost | enbitanem | Query | 583 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 5604 | enbitanem_ | localhost | enbitanem | Query | 558 | Locked | DELETE FROM smf_log_online

    | 930 | enbitanem_ | localhost | enbitanem | Query | 15 | updating | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND OR ID_MEMBER = 1389 |
    | 933 | enbitanem_ | localhost | enbitanem | Query | 14 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 949 | enbitanem_ | localhost | enbitanem | Query | 12 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 957 | enbitanem_ | localhost | enbitanem | Query | 11 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 960 | enbitanem_ | localhost | enbitanem | Query | 11 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 965 | enbitanem_ | localhost | enbitanem | Query | 10 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 974 | enbitanem_ | localhost | enbitanem | Query | 9 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 1015 | enbitanem_ | localhost | enbitanem | Query | 4 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 1016 | enbitanem_ | localhost | enbitanem | Query | 4 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 1032 | mayber | localhost | atstic | Sleep | 1 | | NULL |
    | 1035 | enbitanem_ | localhost | enbitanem | Query | 2 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 1036 | muhasebe_joom1 | localhost | muhasebe_joom1 | Sleep | 2 | | NULL |
    | 1037 | enbitanem_ | localhost | enbitanem | Query | 2 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 1044 | enbitanem_ | localhost | enbitanem | Query | 1 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 1045 | admin | localhost | NULL | Query | 0 | NULL | show processlist |
    | 1047 | enbitanem_ | localhost | enbitanem | Query | 1 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 1051 | enbitanem_ | localhost | enbitanem | Query | 1 | Locked | DELETE FROM smf_log_online
    WHERE logTime < NOW() - INTERVAL 90000 SECOND |
    | 1052 | enbitanem_ | localhost | enbitanem | Sleep | 0 | | NULL
    Arkadaşlar kulldığım forum scripti SMF
    sorun yukarıdaki gibi ve bir mail gelmiş PMA bilgim fazla yok
    siteyi hosting şuan kapatmak zorunda kalmış ve yardımcı olabilecek tecrübeli arkadaş arıyorum
  • 23-12-2008, 01:16:49
    #2
    Alıntı
    Bugün En Çok Online: 10343. En Çok Online: 12786 (18 Kasım 2008, 20:19:05)
    Online olma süresini kısaltmayı deneyebiliriniz.
    Online üyeler bölümünü ayrı bir sayfaya taşımayı deneyebilirsiniz.
    Muhtemelen nedeni bu.
  • 23-12-2008, 08:10:25
    #3
    Üyeliği durduruldu
    KompLo adlı üyeden alıntı: mesajı görüntüle
    Online olma süresini kısaltmayı deneyebiliriniz.
    Online üyeler bölümünü ayrı bir sayfaya taşımayı deneyebilirsiniz.
    Muhtemelen nedeni bu.
    Bende aynı şeyi düşündüm çünkü online süresini 1440 dakika olarak ayarlamıştım ve bu konuda cevap bekliyorum hostingten
    teşekkürler arkadaşım
  • 23-12-2008, 08:17:36
    #4
    Komplo'nun da dediği gibi Sorun online olma süresinden kaynaklanmakta. İlla düşürmenize gerek yok, ayrı bir sayfaya da alabilirsiniz..
  • 23-12-2008, 09:52:26
    #5
    Üyeliği durduruldu
    bayGaReZ adlı üyeden alıntı: mesajı görüntüle
    Komplo'nun da dediği gibi Sorun online olma süresinden kaynaklanmakta. İlla düşürmenize gerek yok, ayrı bir sayfaya da alabilirsiniz..
    Ayrı sayfa demekle kastedileni anlamadım arkadaşlar who sorgusunu index.template.php denmi kaldırayım?
  • 23-12-2008, 13:22:36
    #6
    Evet istatistiklerdeki online üyeler bölümünü başka bir sayfaya taşıyabilirsiniz. Böylece sitenize giren her bir kişi için ayrıca sql sorgusu çalıştırılmamış olur.

    Bkz..