Mysql high cpu usage tapi low memori usage

Discussion in 'Dedicated Server dan Colocation' started by lopikunik, 16 Nov 2012.

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

    lopikunik Beginner 2.0

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6
    Numpang nanya nih master" server mysql saya terjadi serperti ini : "Mysql high cpu usage tapi low memori usage"
    solusinya gmna ya, biar pemakaian cpunya bisa dialihkan ke memori.

    terimakasih.
     
  2. bintang

    bintang Apprentice 2.0

    Messages:
    434
    Likes Received:
    43
    Trophy Points:
    28
    Investigasi sql nya mas, ato batasin concurent proses nya. Paling enak cpu nya yang ditambah, hehehe...

    #just kidding#
     
  3. lopikunik

    lopikunik Beginner 2.0

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6
    Caranya giman ya untuk batsin concurent proses nya. klo ada tutorialnya kasih tau donk.
     
  4. bintang

    bintang Apprentice 2.0

    Messages:
    434
    Likes Received:
    43
    Trophy Points:
    28
    Klo control panel nya pake cpanel coba liat di forum cpanel, ada konfigurasi sederhananya disana. Tapi klo ga pake cpanel, ya coba mas intip di forum dari developer yang mas pake.
     
  5. lopikunik

    lopikunik Beginner 2.0

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6
    ga pakai cpanel, klo setting ke my.cnf nya langsung gmna?
     
  6. BennyKusman

    BennyKusman Hosting Guru DWH Guardian Web Hosting (Company)

    Messages:
    2,234
    Likes Received:
    239
    Trophy Points:
    63
    setting my.cnf nya apa default ?
    di folder2 my.cnf itu, juga ada sample settingnya juga..
     
  7. lopikunik

    lopikunik Beginner 2.0

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6
    Udah ga default, udah banyak di tune
     
  8. perdhanahost

    perdhanahost Expert 1.0

    Messages:
    986
    Likes Received:
    147
    Trophy Points:
    43
  9. cpserv

    cpserv Expert 1.0

    Messages:
    866
    Likes Received:
    123
    Trophy Points:
    43
    coba dicek dulu + ikutin sarannya dari mysqltuner.pl sama tuning-primer.sh

    biasanya sih karena kebanyakan nulis di hard disk langsung (ga ngecache) jadinya load cpu naik (waktu tunggunya kelamaan)
     
  10. .Ghost.

    .Ghost. Beginner 2.0

    Messages:
    13
    Likes Received:
    1
    Trophy Points:
    3
    Coba periksa proses list mysql nya. Masuk ke mysql trus ketikkan perintah berikut:
    > show processlist;

    cek terus dengan perintah itu, biasanya ada query yg lama prosesnya atau sleep.

    CMIIW
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...