Optimasi Mysql

Discussion in 'VPS (Virtual Private Server)' started by YuuNoa, 14 May 2016.

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

    YuuNoa Poster 1.0

    Messages:
    98
    Likes Received:
    7
    Trophy Points:
    8
    Seperti judulnya, saya mau tanya optimasi mysql yang bagusnya gimana ya, selama ini masih pakek settingan default. berhubung saya pakek webmin jadi udah ada beberapa settingan, spek 1 core 1 gb ram 40 gb hdd, apa mungkin settingan yang dari webmin ini kurang harus ada beberapa tambahannya lagi?

    hy.jpg
    thx
     
  2. pedagang

    pedagang Expert 1.0

    Messages:
    674
    Likes Received:
    109
    Trophy Points:
    43
  3. YuuNoa

    YuuNoa Poster 1.0

    Messages:
    98
    Likes Received:
    7
    Trophy Points:
    8
  4. YuuNoa

    YuuNoa Poster 1.0

    Messages:
    98
    Likes Received:
    7
    Trophy Points:
    8
  5. YuuNoa

    YuuNoa Poster 1.0

    Messages:
    98
    Likes Received:
    7
    Trophy Points:
    8
  6. MyhostingID

    MyhostingID Poster 2.0

    Messages:
    151
    Likes Received:
    11
    Trophy Points:
    18
    opimalkan lagi /etc/my.cnf nya
     
  7. pedagang

    pedagang Expert 1.0

    Messages:
    674
    Likes Received:
    109
    Trophy Points:
    43
    kalau pemakaian memory kecil sedangkan cpu sudah over :35: au ah gelap
     
  8. YuuNoa

    YuuNoa Poster 1.0

    Messages:
    98
    Likes Received:
    7
    Trophy Points:
    8
    jadi gimana pak? :20:
     
  9. pedagang

    pedagang Expert 1.0

    Messages:
    674
    Likes Received:
    109
    Trophy Points:
    43
    kalau terlanjur ya sudah, diolah apa adanya

    1. pilih myisam
    2. cache mysql diaktifkan, atau hapus text-nya, biar default aktif (ini nyerap memory)
    3. memcache atau yg sejenis (ini juga nyerap memory)

    kalau sudah aktif, konfig php juga perlu diperhatikan, karena biasanya php juga nyerap CPU gede
    misalnya kalau php-fpm
    - pilih statik
    - max children dibikin kecil, misalnya 3

    #mungkin, saya juga sedang belajar di sini
     
  10. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Kalau RAM sudah 1GB sebenarnya sudah cukup 'leluasa' untuk 'dimainkan'. Walaupun demikian, pakai innodb sebagai storage-engine untuk mysql dalam banyak kasus adalah 'mubazir'.
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...