1. Halo Guest, pastikan Anda selalu menaati peraturan forum sebelum mengirimkan post atau thread baru.

[ASK] Mysql Server Sering Down

Discussion in 'Hosting & Domain' started by RyanDotID, Dec 10, 2014.

  1. RyanDotID

    RyanDotID Banned

    Joined:
    Dec 10, 2014
    Messages:
    37
    Likes Received:
    1
    Gan, Tanya nih, Setelah ane pindah ke Vultr , hosting Ram 2GB, pakai cPanel, Litespeed dengan website traffic 10k uv/day. kenapa sering down yah mysql nya.
    kira2 di ada masalah dimana? apa dari penyedia servernya. sebelumnya host di lain tempat aman2 saja..

    Thanks.
     
    RyanDotID, Dec 10, 2014
    #1
  2. herans

    herans Ads.id Pro

    Joined:
    Apr 15, 2013
    Messages:
    266
    Likes Received:
    108
    hrs nya spek segitu ngga bikin mysql mati. kalo menghadapi mysql yang sudah mati pernah dibahas oleh agan rancaf di sini http://ads.id/forums/showthread.php/197346?p=2574070#post2574070 , yakni dengan menambahkan kode :

    max_connections=1024000
    max_allowed_packet=1000M

    pafa konfigurasi mysql nya. baca aja langsung d trit itu.
     
    herans, Dec 11, 2014
    #2
  3. masbayu22

    masbayu22 Super Hero

    Joined:
    May 18, 2011
    Messages:
    1,288
    Likes Received:
    95
    Location:
    Kulivps.com
    Setingan max_connections kalo menurutku harus menyesuaikan spek RAM. Itu RAM cuma 2GB, kalo max_connections diset ke 1024000 bisa bisa PHP dan Litespeed gk kebagian jatah RAM donk, bisa habis di MySQL semua. Hehehehe... Karena saat max_connections diset ke 50 aja habisnya RAM sekitar 300MBan, tinggal kalikan aja tuh... Hehehe Buat om TS, itu blognya manual atau AGC atau Dojo? Soalnya rata rata AGC tewasnya di MySQL.... :D
     
    masbayu22, Dec 11, 2014
    #3
  4. RyanDotID

    RyanDotID Banned

    Joined:
    Dec 10, 2014
    Messages:
    37
    Likes Received:
    1
    Manual gan. soalnya untuk portal berita....
     
    RyanDotID, Dec 11, 2014
    #4
  5. BUPATI

    BUPATI Newbie

    Joined:
    Dec 18, 2014
    Messages:
    18
    Likes Received:
    1
    Biasanya masalah alokasi ram minim, harusnya udh bisa dgn tips diatas
     
    BUPATI, Dec 19, 2014
    #5
  6. siprof

    siprof Reviewer

    Joined:
    Jun 4, 2011
    Messages:
    845
    Likes Received:
    28
    silaken ke _http://www.omh.cc/mycnf/
    lalu copy paste isi my.cnf agan di sana
     
    siprof, Jan 2, 2015
    #6
  7. steven.j

    steven.j Hosting Provider

    Joined:
    Oct 29, 2014
    Messages:
    91
    Likes Received:
    1
    itu cpunya berapa cores gan ?
    coba dicek lognya ada high load engga, kalau hanya 2 cores kemungkinan kurang...
    coba aktifkan juga fitur monitoring di cPanel, jadi kalau mysql down nanti akan otomatis restart dan langsung up lg
     
    steven.j, Jan 2, 2015
    #7
  8. BurgerKiLL

    BurgerKiLL Ads.id Pro

    Joined:
    May 29, 2013
    Messages:
    476
    Likes Received:
    46
    Location:
    Just BurgerKill Fans
    harus dicek dlu dari awal, spek vpsnya berapa? menggunakan control panel apa?
     
    BurgerKiLL, Jan 2, 2015
    #8
  9. xrvel

    xrvel Super Hero

    Joined:
    Oct 21, 2007
    Messages:
    2,873
    Likes Received:
    947
    Location:
    Di sini
    bisa cek mysql error log nya & apache (atau litespeed) error log, kalau nggak bisa akses lognya bisa minta bantuan ke hosting.
     
    xrvel, Jan 4, 2015
    #9
  10. nasdin

    nasdin Super Hero

    Joined:
    May 28, 2013
    Messages:
    806
    Likes Received:
    182
    ada random post?

    pakai cache ga?
     
    nasdin, Jan 4, 2015
    #10

Share This Page