Help!! ==> Masalah di MySql (VPS)

Discussion in 'Masalah Teknik dan Keamanan' started by jujuhack, 21 Aug 2014.

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

    jujuhack Poster 1.0

    Messages:
    54
    Likes Received:
    1
    Trophy Points:
    8
    Pagi Tuan.. ada yang pernah ngalamin masalah seperti ini tidak ?
    di VPS Linux

    mysql> select * from nama_tabel;
    ERROR 1286 (42000): Unknown storage engine 'InnoDB'
    mysql> select * from nama_tabel;
    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...
    Connection id: 11
    Current database: dilmil11_db
     
  2. dhyhost

    dhyhost Hosting Guru Web Hosting

    Messages:
    3,932
    Likes Received:
    614
    Trophy Points:
    113
    itu karena mysqlnya ngga support innodb,
    coba diaktifkan dulu innodbnya...

    VPSnya pakai panel apa ?
     
  3. jujuhack

    jujuhack Poster 1.0

    Messages:
    54
    Likes Received:
    1
    Trophy Points:
    8
    Panel VPSnya SolusVM, Virtualnya OpenVZ, kalau ga support apa bisa diaktifin ya ? gimana caranya ? Thx
     
  4. jetdino

    jetdino Apprentice 2.0

    Messages:
    401
    Likes Received:
    32
    Trophy Points:
    28
    pakai mysql versi berapa?
     
  5. jujuhack

    jujuhack Poster 1.0

    Messages:
    54
    Likes Received:
    1
    Trophy Points:
    8
    mysql versi 5.5.37 Tuan
     
  6. LIMS

    LIMS Poster 2.0

    Messages:
    137
    Likes Received:
    51
    Trophy Points:
    28
    cek via ssh /etc/my.cnf
    PHP:
    skip-inndob
    jika ada itu hapus >> save..

    dan jika ingin merubah innodb ke default bs pakai ini
    PHP:
    default-table-type=innodb
    semoga membantu...
     
  7. LIMS

    LIMS Poster 2.0

    Messages:
    137
    Likes Received:
    51
    Trophy Points:
    28
    sorry telat edit post :21:
    bisa cek pakai ini status innodb nya
    PHP:
    # mysqladmin var | grep have_innodb
     
  8. pluto01

    pluto01 Hosting Guru Web Hosting

    Messages:
    3,668
    Likes Received:
    755
    Trophy Points:
    113
    yupz
    cek status innodb
    mysql> show engines;
    mysql> show variables like 'have_innodb';
    atau
    show engine innodb status;
    pastikan nano /etc/my.cnf tak ada skip-innodb
     
  9. jujuhack

    jujuhack Poster 1.0

    Messages:
    54
    Likes Received:
    1
    Trophy Points:
    8
    root@server [~]# mysqladmin var | grep have_innodb
    | have_innodb | YES |

    tapi cnfnya isinya cuma ini
    root@server [~]# cat /etc/my.cnf
    [mysqld]
    max_allowed_packet=268435456
    open_files_limit=18378
    innodb_buffer_pool_size=134217728
     
  10. jujuhack

    jujuhack Poster 1.0

    Messages:
    54
    Likes Received:
    1
    Trophy Points:
    8
    masalah innodbnya sih udah Bang, tapi masih Error sitenya, 3 kali akses error, akses ke 4 berhasil trus error lagi...
    Masalahnya dimana ya ?
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...