MYSQL High Usage

Discussion in 'VPS (Virtual Private Server)' started by rina, 24 Mar 2015.

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

    rina Beginner 2.0

    Messages:
    13
    Likes Received:
    1
    Trophy Points:
    3
    Sore mastah",, mau tanya kenapa kalo saya view di htop, service mysql connection timenya sangat lama ya ?
    kadang sampai 20an hour.

    berikut saya attach screenshotnya.
     

    Attached Files:

    • vps.jpg
      vps.jpg
      File size:
      217.7 KB
      Views:
      39
  2. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Bukannya mysql sebaiknya tidak putus-putus koneksinya?. Kalau php-fpm pool memang akan 'diputus' jika request sudah selesai.
     
  3. rina

    rina Beginner 2.0

    Messages:
    13
    Likes Received:
    1
    Trophy Points:
    3
    oh gitu ya mastah.. maklum newbie baru mulai belajar.. kalo load average kadang sampai angka 4, apakah itu wajar juga mastah ? di vpsnya saya hosting 2 domain saja

    vps 8core, 6GB RAM
     
  4. Rail Media

    Rail Media Apprentice 1.0

    Messages:
    295
    Likes Received:
    28
    Trophy Points:
    28
    Vps pake kvm apa ovz itu
     
  5. junior riau

    junior riau Hosting Guru Web Hosting

    Messages:
    3,228
    Likes Received:
    515
    Trophy Points:
    113
    load max nya sama dengan jumlah corenya
     
  6. pangeran1995

    pangeran1995 Hosting Guru

    Messages:
    1,352
    Likes Received:
    105
    Trophy Points:
    63
    kalo mysql tinggi wajar om selama ga down mysql :D
     
  7. jaapns

    jaapns Hosting Guru Web Hosting

    Messages:
    3,260
    Likes Received:
    443
    Trophy Points:
    83
    beda spek beda load , load tinggi spek server hebat mah akselarasi tetap jos
     
  8. Rail Media

    Rail Media Apprentice 1.0

    Messages:
    295
    Likes Received:
    28
    Trophy Points:
    28
    ada harga ada rupa :15:
     
  9. 1stserver

    1stserver Hosting Guru Web Hosting

    Messages:
    1,801
    Likes Received:
    174
    Trophy Points:
    63
    kalau traffic dan user sudah sangat tinggi meskipun speks server tinggi biasanya memang yg gak kuat (bottle-neck) di MySQL-nya. Alternatif database yang lebih baik dan lebih kuat daripada MySQL apa yach? tapi masih tetap jalan dengan cPanel dan masih open source alias gratis.
     
  10. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Pakai MariaDB sama saja (atau tidak beda jauh) jika pakai storage-engine yang sama. Jika masih pakai myisam sebagai storeage-engine mungkin bisa diganti ke innodb (ada di mysql dan mariadb), aria (hanya di mariadb) atau tokudb (hanya di mariadb).
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...