[ASK] Mysql sering time out

Discussion in 'Dedicated Server dan Colocation' started by java09, 23 May 2014.

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

    java09 Poster 2.0

    Messages:
    108
    Likes Received:
    1
    Trophy Points:
    18
    pagi Tuan, mau nanyak kenapa ya mysql server saya sering time out jadinya pas restore database gak normal jadi cuma setengah aja yg ke restore.

    apa gara2 ini : http://prntscr.com/3llcnq

    dari kemarin nyoba cari cara untuk monitoring user mana yg pengunaan mysql gede tapi gak dapat2 ada saran Tuan??

    thanks
     
  2. java09

    java09 Poster 2.0

    Messages:
    108
    Likes Received:
    1
    Trophy Points:
    18
  3. gonggo

    gonggo Poster 1.0

    Messages:
    53
    Likes Received:
    6
    Trophy Points:
    8
    coba gedein wait_timeout atau interactive_timeout di my.cnf
     
  4. vishualhost

    vishualhost Expert 2.0

    Messages:
    813
    Likes Received:
    81
    Trophy Points:
    28
    itu mysqlnya klo lg tidak restore cpu usagenya sebesar itu atau dibawah 10% mas ?
     
  5. java09

    java09 Poster 2.0

    Messages:
    108
    Likes Received:
    1
    Trophy Points:
    18
    di my.cnf cm ini mas isinya : http://prntscr.com/3lqmg4
     
  6. java09

    java09 Poster 2.0

    Messages:
    108
    Likes Received:
    1
    Trophy Points:
    18
    sebesar itu mas cpunya untuk mysql
     
  7. gonggo

    gonggo Poster 1.0

    Messages:
    53
    Likes Received:
    6
    Trophy Points:
    8
    kagak ada timeout disitu, coba cek dari console/prompt mysql
    Code:
    mysql> SHOW VARIABLES LIKE "%timeout%";
     
  8. java09

    java09 Poster 2.0

    Messages:
    108
    Likes Received:
    1
    Trophy Points:
    18
    ini Tuan : http://prntscr.com/3lqvry
     
  9. vishualhost

    vishualhost Expert 2.0

    Messages:
    813
    Likes Received:
    81
    Trophy Points:
    28
    mungkin ada db user yg sangat besar mas , sudah coba dicek blm
     
  10. gatotkacahost.com

    gatotkacahost.com Poster 1.0

    Messages:
    193
    Likes Received:
    26
    Trophy Points:
    28
    Coba ss Proses Manager semuanya mas...
    di cek ada proses yg berjalan selain itu atau tidak...
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...