Suspended Hosting Karena ini. bagaimana Cara mengatasi?

Discussion in 'Masalah Teknik dan Keamanan' started by Okefix, 28 Mar 2016.

Thread Status:
Not open for further replies.
  1. Okefix

    Okefix Beginner 1.0

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Selamat Pagi..

    Ini posting pertama disini mohon master-master siap menjawab ya.
    Baru pertama kali sejak 4 tahun ini pake selfhosting dan kena suspended. Alasannya seperti ini.
    Query 27 Waiting for table level lock SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4844) ORDER BY meta_id ASC
    Query 28 Waiting for table level lock UPDATE `wp_postmeta` SET `meta_value` = '3318' WHERE `post_id` = 1884 AND `meta_key` = 'post_views_c
    Query 28 Copying to tmp table SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts
    Query 27 Waiting for table level lock SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4844) ORDER BY meta_id ASC


    Terus yang saya tanyakan bagaimana mengatasi itu?
     
  2. dhyhost

    dhyhost Hosting Guru Web Hosting

    Messages:
    3,927
    Likes Received:
    613
    Trophy Points:
    113
    apa itu?
    penggunaan mysql yg ckup tinggi ?
     
  3. pluto01

    pluto01 Hosting Guru Web Hosting

    Messages:
    3,653
    Likes Received:
    755
    Trophy Points:
    113
    apakah suspen karena penggunaan proses mysqlnya tinggi atau ?
     
  4. Okefix

    Okefix Beginner 1.0

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    iya penggunaan Mysql terlalu tinggi.. bagaimana ya caranya? sudah di deactive semua plugin tetep sama.
     
  5. idnix

    idnix Hosting Guru

    Messages:
    1,003
    Likes Received:
    189
    Trophy Points:
    63
    paket hostingnya yang berapa tuh?
     
  6. galuh82

    galuh82 Hosting Guru Web Hosting (Company)

    Messages:
    2,514
    Likes Received:
    186
    Trophy Points:
    63
    mungkin pid processnya di sisi server masih running .. minta di kill saja dulu semua.. trus monitor lagi apabila masih tinggi harus mulai dipertimbangkan menggunakan VPS :)
     
  7. Okefix

    Okefix Beginner 1.0

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Paket yang 300rb/tahun
     
  8. Okefix

    Okefix Beginner 1.0

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Oke Tuan di coba.. Masa ya gak kuat visitor belum ada 500. :20:
     
  9. pluto01

    pluto01 Hosting Guru Web Hosting

    Messages:
    3,653
    Likes Received:
    755
    Trophy Points:
    113
    Speknya mas ?
     
  10. funkyasa

    funkyasa Expert 1.0

    Messages:
    633
    Likes Received:
    57
    Trophy Points:
    28
    Itu hasil mytop ya?
    Kalau berat di mysql memang agak sulit ngeliatnya dari sisi user. Optimasi database apa yang sudah dilakukan?
    Autoblog? STT? etc..?
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...