Tolong pilih kategori sesuai, jenis posting (diskusi atau bukan) dan sertakan tag/topik yang sesuai seperti komputer, java, php, mysql, dll. Promosi atau posting tidak pada tempatnya akan kami hapus!
- Bagi Anda yang ingin mendaftar, baca link berikut:
http://diskusiweb.com/discussion/50491/how-to-registrasi-diskusiweb-com-baca-ini-terlebih-dahulu
- Cara menyisipkan kode program supaya tampil rapi dan terformat dengan baik di diskusiweb.com: http://www.diskusiweb.com/discussion/50415/cara-menyisipkan-kode-program-di-diskusiweb-com
- Cara posting gambar/image di post Anda: http://www.diskusiweb.com/discussion/47345/cara-menyisipkan-menyertakan-image-pada-posting/p1

ask #2002 Cannot log in to the MySQL server pada linux

Master

mohon dibantu tiba" hari ini saat masuk ke phpadmin muncul comment spt ini
#2002 Cannot log in to the MySQL server
saat login trus masukkan password

Comments

  • mysql server nya mati :D

    web server nya sih idup,
    soalnya phpmyadmin masih jalan
  • edited May 2015
    aq coba masuk aplikasi yah gak mau
    tapi kalo ke localhost langsung masuk ke xampp

    ini biasanya jalan tumben hari ini langsung begini

    anehnya juga spt ini

    sis sis # sudo /opt/lampp/lampp stop
    Stopping XAMPP for Linux 1.8.3-4...
    XAMPP: Stopping Apache...ok.
    XAMPP: Stopping MySQL...ok.
    sis sis # sudo /opt/lampp/lampp start
    Starting XAMPP for Linux 1.8.3-4...
    XAMPP: Starting Apache...ok.
    XAMPP: Starting MySQL...already running.
    sis sis #


  • jangan lewat lampp stop

    langsung pake mysqld nya
  • caranya master ???

  • nyoba dengan begini ( dpt dr googling) juga gak bisa


    ; Default socket name for local MySQL connects.  If empty, uses the built-in
    ; MySQL defaults.
    ; http://php.net/pdo_mysql.default-socket
    pdo_mysql.default_socket= /opt/lampp/var/mysql/mysql.sock
  • aq coba ganti di
     /opt/lampp/phpmyadmin/confog.inc.php
    &
     /opt/lampp/phpmyadmin/confog.sample.inc.php

    $cfg['Servers'][$i]['host'] = 'localhost';

    to:

    $cfg['Servers'][$i]['host'] = '127.0.0.1';

    tetap tidak bisa......

    <br>

    :(( :(( :((
  • ini salahnya dimana ya master ??kemarin-kemarin lancar gak masalah....apa ada yg utak utik ya ? tp gk ada yg tau passwordnya kok tiba" jadi begini....
    mohon dibantu manter ...
    [-O< [-O< [-O< [-O< [-O<
  • edited May 2015
    kagak ada hubungannya dgn seting

    mysql elo cuma mati

    shutdown dulu
    lalu start lagi service nya

    elo cari mysqld nya lampp ada dimana
    jalankan dari situ

    sudo mysqld stop
    sudo mysqld start

    sudah cuma itu

    kalo ada yg salah, pasti mysql nya laporan sendiri salahnya apa
  • tak coba master jangan ditinggal...puyeng nie dari tadi gak mau juga
  • "jangan ditinggal" gimana ?

    ini os gw lagi error, mau gw format :))
  • edited May 2015
    sis sis # sudo mysqld stop
    sudo: mysqld: command not found


    kok gini kommentnya master ??

  • Tetap gak bisa master....

    sis sis # sudo /opt/lampp/lampp mysqlid stop
    Usage: lampp <action>

        start         Start XAMPP (Apache, MySQL and eventually others)
        startapache   Start only Apache
        startmysql    Start only MySQL
        startftp      Start only ProFTPD

        stop          Stop XAMPP (Apache, MySQL and eventually others)
        stopapache    Stop only Apache
        stopmysql     Stop only MySQL
        stopftp       Stop only ProFTPD

        reload        Reload XAMPP (Apache, MySQL and eventually others)
        reloadapache  Reload only Apache
        reloadmysql   Reload only MySQL
        reloadftp     Reload only ProFTPD

        restart       Stop and start XAMPP
        security      Check XAMPP's security

        enablessl     Enable SSL support for Apache
        disablessl    Disable SSL support for Apache

        backup        Make backup file of your XAMPP config, log and data files

        oci8          Enable the oci8 extenssion

        panel         Starts graphical XAMPP control panel

    sis sis # sudo /opt/lampp/lampp mysqlid start
    Usage: lampp <action>

        start         Start XAMPP (Apache, MySQL and eventually others)
        startapache   Start only Apache
        startmysql    Start only MySQL
        startftp      Start only ProFTPD

        stop          Stop XAMPP (Apache, MySQL and eventually others)
        stopapache    Stop only Apache
        stopmysql     Stop only MySQL
        stopftp       Stop only ProFTPD

        reload        Reload XAMPP (Apache, MySQL and eventually others)
        reloadapache  Reload only Apache
        reloadmysql   Reload only MySQL
        reloadftp     Reload only ProFTPD

        restart       Stop and start XAMPP
        security      Check XAMPP's security

        enablessl     Enable SSL support for Apache
        disablessl    Disable SSL support for Apache

        backup        Make backup file of your XAMPP config, log and data files

        oci8          Enable the oci8 extenssion

        panel         Starts graphical XAMPP control panel

    sis sis #

  • edited May 2015
    kok aneh mysql gak bisa stop
    PC aq restart

    saat aq jalankan dari terminal seolah-olah mysql mmg sudah running

    sis sis # sudo /opt/lampp/lampp start
    Starting XAMPP for Linux 1.8.3-4...
    XAMPP: Starting Apache...ok.
    XAMPP: Starting MySQL...already running.



    Kemudian saat aq stop
    sis sis # sudo /opt/lampp/lampp stop
    Stopping XAMPP for Linux 1.8.3-4...
    XAMPP: Stopping Apache...ok.
    XAMPP: Stopping MySQL...ok.
    sis sis #

    terlihat OK mau stop  saat start ttp terlihat sudah running

    sis sis # sudo /opt/lampp/lampp stopmysql
    XAMPP: Stopping MySQL...ok.
    sis sis # sudo /opt/lampp/lampp startmysql
    XAMPP: Starting MySQL...already running.
    sis sis #


  • sis sis # sudo /etc/init.d/mysqld stop
    sudo: /etc/init.d/mysqld: command not found

  • master kok aq gak ketemu mysqld ??
    aq search di linux tidak ada

    adanya

    /opt/lampp/bin/mysqld_multi
    /opt/lampp/bin/mysqld_safe
    /opt/lampp/bin/mysqldump
    /opt/lampp/bin/mysqldumpslow

    Tolongin master kok gak bisa...?? smp jam segini juga blm ketemu
  • nah muncul seperti ini master apa artinya ?????
    [-O< [-O<

    sis sis # sudo /opt/lampp/sbin/mysqld start
    2015-05-04 23:57:47 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    2015-05-04 23:57:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2015-05-04 23:57:47 3167 [Note] Plugin 'FEDERATED' is disabled.
    2015-05-04 23:57:47 3167 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2015-05-04 23:57:47 3167 [Note] InnoDB: The InnoDB memory heap is disabled
    2015-05-04 23:57:47 3167 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2015-05-04 23:57:47 3167 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2015-05-04 23:57:47 3167 [Note] InnoDB: Using CPU crc32 instructions
    2015-05-04 23:57:47 3167 [Note] InnoDB: Initializing buffer pool, size = 7.8G
    2015-05-04 23:57:47 3167 [Note] InnoDB: Completed initialization of buffer pool
    2015-05-04 23:57:47 3167 [Note] InnoDB: Highest supported file format is Barracuda.
    2015-05-04 23:57:48 3167 [Note] InnoDB: 128 rollback segment(s) are active.
    2015-05-04 23:57:48 3167 [Note] InnoDB: Waiting for purge to start
    2015-05-04 23:57:48 3167 [Note] InnoDB: 5.6.16 started; log sequence number 2098133940
    /opt/lampp/sbin/mysqld: Too many arguments (first extra is 'start').
    Use --verbose --help to get a list of available options
    2015-05-04 23:57:48 3167 [ERROR] Aborting

  • Master

    apa ini berarti innodb_log_file_size =256M harus dibesarkan lagi ????
    apa bisa dikecilkan ????

    apa artinya ini set
    innodb_fast_shutdown to 1: 
    ??? apa ini bisa membantu ? apa data akan hilang atau crash ???

    Mohon petunjuknya master ....aq mst gmn nie ???



    [-O< [-O< [-O<


    image
  • edited May 2015
    sudah dicoba gedeen innodb_log_file_size nya dari 256 M ke 500M tetap tidak bisa....

    /opt/lampp/var/mysql/ibdata1
    /opt/lampp/var/mysql/ib_logfile0
    /opt/lampp/var/mysql/ib_logfile1

    file ke tiganya sy coba replace kemudian msqld stop trus start
    muncul spt ini :

    sis sis # sudo /opt/lampp/sbin/mysqld start
    2015-05-05 04:42:20 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    2015-05-05 04:42:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2015-05-05 04:42:20 3608 [Note] Plugin 'FEDERATED' is disabled.
    2015-05-05 04:42:20 3608 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2015-05-05 04:42:20 3608 [Note] InnoDB: The InnoDB memory heap is disabled
    2015-05-05 04:42:20 3608 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2015-05-05 04:42:20 3608 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2015-05-05 04:42:20 3608 [Note] InnoDB: Using CPU crc32 instructions
    2015-05-05 04:42:20 3608 [Note] InnoDB: Initializing buffer pool, size = 11.7G
    2015-05-05 04:42:21 3608 [Note] InnoDB: Completed initialization of buffer pool
    2015-05-05 04:42:21 3608 [Note] InnoDB: Highest supported file format is Barracuda.
    2015-05-05 04:42:21 3608 [Note] InnoDB: 128 rollback segment(s) are active.
    2015-05-05 04:42:21 3608 [Note] InnoDB: Waiting for purge to start
    2015-05-05 04:42:21 3608 [Note] InnoDB: 5.6.16 started; log sequence number 1600634
    /opt/lampp/sbin/mysqld: Too many arguments (first extra is 'start').
    Use --verbose --help to get a list of available options
    2015-05-05 04:42:21 3608 [ERROR] Aborting

    2015-05-05 04:42:21 3608 [Note] Binlog end
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'partition'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'ARCHIVE'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_METRICS'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_CMP'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_LOCKS'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'INNODB_TRX'
    2015-05-05 04:42:21 3608 [Note] Shutting down plugin 'InnoDB'
    2015-05-05 04:42:21 3608 [Note] InnoDB: FTS optimize thread exiting.
    2015-05-05 04:42:21 3608 [Note] InnoDB: Starting shutdown...
    2015-05-05 04:42:23 3608 [Note] InnoDB: Shutdown completed; log sequence number 1600644
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'BLACKHOLE'
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'MRG_MYISAM'
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'MyISAM'
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'MEMORY'
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'CSV'
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'sha256_password'
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'mysql_old_password'
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'mysql_native_password'
    2015-05-05 04:42:23 3608 [Note] Shutting down plugin 'binlog'
    2015-05-05 04:42:23 3608 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

    sis sis #

  • iya, itu log nya innodb sudah bengkak

    kalo masalah memperbsar log :
    https://tag1consulting.com/InnoDB_Performance_Tuning

    tapi, kalo kagak salah elo pan sudah pernah dikasih tau :
    kalo pake innodb jangan pake model yg 1 file segede gajah
    tapi pisah per table per file
  • edited May 2015
    Master kasi solusi mohon dibantu.....trus aq mesti gimana ini ???

    aq sudah pakai innodb_file_per_table juga....mohon master


    # Comment the following if you are using InnoDB tables
    #skip-innodb
    innodb_file_per_table
    innodb_data_home_dir = /opt/lampp/var/mysql/
    innodb_data_file_path = ibdata1:10M:autoextend
    innodb_log_group_home_dir = /opt/lampp/var/mysql/
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    innodb_buffer_pool_size = 12000M
    # Deprecated in 5.6
    # innodb_additional_mem_pool_size = 20M
    # Set .._log_file_size to 25 % of buffer pool size
    innodb_log_file_size = 500M
    innodb_log_buffer_size = 32M
    innodb_flush_log_at_trx_commit = 1
    innodb_lock_wait_timeout = 500000

    [mysqldump]
    quick
    max_allowed_packet = 1024M

    Tetap tidak bisa master
  • edited May 2015
    sudah coba dengan begini

    # Comment the following if you are using InnoDB tables
    #skip-innodb
    innodb_file_per_table=1
    innodb_data_home_dir = /opt/lampp/var/mysql/
    innodb_data_file_path = ibdata1:10M:autoextend
    innodb_log_group_home_dir = /opt/lampp/var/mysql/
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    innodb_buffer_pool_size = 12000M
    # Deprecated in 5.6
    # innodb_additional_mem_pool_size = 20M
    # Set .._log_file_size to 25 % of buffer pool size
    innodb_log_file_size = 500M
    innodb_log_buffer_size = 16M
    innodb_flush_log_at_trx_commit = 1
    sync_binlog=1
    innodb_lock_wait_timeout = 500000

    [mysqldump]
    quick
    max_allowed_packet = 1024M

    tetap aja tidak bisa....apa memang harus install ulang ya master ???
    memang tidak bisa ???
    tapi gimana caranya backup datebase nya kalau mysql nya mati ???

    sis sis # sudo /opt/lampp/sbin/mysqld start
    2015-05-05 07:01:18 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    2015-05-05 07:01:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2015-05-05 07:01:18 2525 [Note] Plugin 'FEDERATED' is disabled.
    2015-05-05 07:01:18 2525 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2015-05-05 07:01:18 2525 [Note] InnoDB: The InnoDB memory heap is disabled
    2015-05-05 07:01:18 2525 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2015-05-05 07:01:18 2525 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2015-05-05 07:01:18 2525 [Note] InnoDB: Using CPU crc32 instructions
    2015-05-05 07:01:18 2525 [Note] InnoDB: Initializing buffer pool, size = 11.7G
    2015-05-05 07:01:19 2525 [Note] InnoDB: Completed initialization of buffer pool
    2015-05-05 07:01:19 2525 [Note] InnoDB: Highest supported file format is Barracuda.
    2015-05-05 07:01:19 2525 [Note] InnoDB: 128 rollback segment(s) are active.
    2015-05-05 07:01:19 2525 [Note] InnoDB: Waiting for purge to start
    2015-05-05 07:01:19 2525 [Note] InnoDB: 5.6.16 started; log sequence number 1600614
    /opt/lampp/sbin/mysqld: Too many arguments (first extra is 'start').
    Use --verbose --help to get a list of available options
    2015-05-05 07:01:19 2525 [ERROR] Aborting

    2015-05-05 07:01:19 2525 [Note] Binlog end
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'partition'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'ARCHIVE'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_METRICS'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_CMP'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_LOCKS'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'INNODB_TRX'
    2015-05-05 07:01:19 2525 [Note] Shutting down plugin 'InnoDB'
    2015-05-05 07:01:19 2525 [Note] InnoDB: FTS optimize thread exiting.
    2015-05-05 07:01:19 2525 [Note] InnoDB: Starting shutdown...
    2015-05-05 07:01:21 2525 [Note] InnoDB: Shutdown completed; log sequence number 1600624
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'BLACKHOLE'
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'MRG_MYISAM'
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'MyISAM'
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'MEMORY'
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'CSV'
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'sha256_password'
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'mysql_old_password'
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'mysql_native_password'
    2015-05-05 07:01:21 2525 [Note] Shutting down plugin 'binlog'
    2015-05-05 07:01:21 2525 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

  • sudah bisa belum ?

    os gw baru balik 1 :D
    masih harus install 2 lagi
  • edited May 2015
    hadehhh master ....mau gantung diri rasanya aq....lebay.com

    aq remove lampp trus install ulang

    tapi aq penasaran banget....itu tidak menjawab apapun karena ib_logfile1 dan ib_logfile0 ku pasti akan bertambah banyak dan akan stack lagi

    master pernah ngasi tau utk memakai innodb_file_per_table
    walau sekarang aq pakai innodb_file_per_table = 1 ( mesti tidak tau artinya )

    Mohon diberi pencerahan master

    1. innodb_file_per_table apa bedanya dengan innodb_file_per_table = 1
    2. jika ib_logfile1 dan ib_logfile0membengkak lagi apa yang harus kulakukan ?? apa iya harus terus menambah nilai innodb_log_file_size ???
    3. sync_binlog=1 apa artinya ?? apa pengaruhnya ?

    Mohon pencerahannya master ???

  • pertanyaanya sebenernya balik ke : sebenernya elo pilih pake innodb itu dgn dasar kebutuhan apa ?
  • karena aq buat system aplikasi master jadi mobilitas transaksi keuangan hingga laporan keuangan
    nah aq mikir gak pakai myisam karena aq baca" innodb lebih baik kalo banyak transaksi
  • sebenernya kalo log elo yg error masih ada
    itu dibutuhkan buat tracing masalah ...

    sudah dihapus yo ?
  • iya aq install ulang
    aq jg ragu apa krn log itu jd error
    krn sebelumny listrik jegleg mati...

    master blm jwb 3 pertanyaanku diatas
    :-w
  • yg nomer 1 sama saja

    yg nomer 2, batas nya ada di setting, kagak mungkin lebih dari batas
    kalo lebih, log yg awal biasanya di dispose
    cuma kemarin gw kagak bisa jawab soalnya os error
    jadi kagak bisa reply macam-macam
    gw sempat kepikiran file log corrupt

    yg nomer 3 dipake buat replikasi db
    kagak ngaruh kalo cuma pake 1 engine
  • edited May 2015
    ***batas nya ada di setting, kagak mungkin lebih dari batas
    kalo lebih, log yg awal biasanya di dispose***

    artinya jika aq pasang nilai  innodb_log_file_size= 500M

    kalau log mencapai batas 500 M (melewati ) nantinya akan menimpa data log awal seperti itu master ???

    kalau seperti itu jadi tidak perlu memperbesar nilai  innodb_log_file_size ??


  • gw malah kepikiran buat memperkecil :D
    soalnya handle file jumbo itu juga berat buat cpu

    http://www.psce.com/blog/2012/04/10/what-is-the-proper-size-of-innodb-logs/
    http://www.psce.com/blog/2012/04/04/how-to-resize-innodb-logs/

    kemarin, terakhir gw reply
    gw kepikiran proses logging nya innodb sama dgn proses storage datanya
    ukuran file log tidak dibatasi
    tapi ternyata tidak ( dan gw sudah kagak bisa reply lagi :D )

    saat gw bisa reply lagi ... ternyata sudah elo install ulang
    jadinya kagak bisa memastikan lagi asal muasal masalah dari mana
  • edited May 2015
    Master

    mysql> SET GLOBAL innodb_fast_shutdown=1;

    ini dijalankan dari mana ? dari terminal linux apa dari cnf dipasang ????


    ****saat gw bisa reply lagi ... ternyata sudah elo install ulang
    jadinya kagak bisa memastikan lagi asal muasal masalah dari mana***

    ya master aq sampe 2 hari 2 malam sampe pagi gak ada solusi....kalau crash spt itu semoga OS master saat itu gak masalah lagi sehingga bisa bantu
  • kalo pake SET GLOBAL ... itu pake query

    tapi hal yg sama bisa di set langsung di file config nya mysql
  • Ay donk master yg lebih jelas kok aq gk ngerti
    Hal yg sama bisa diset langsung di file confignya mysql maksudnya di set di cnf nya ??

    Set global pakai query maksudnya jalankan dari phpmyadmin trus masuk datenase trus
    Masuk ke query nya ??? Kok bingung hehe
  • di set di file config mysql : bisa
    itu berarti tiap kali mysql jalan, seting itu juga langsung dipake

    kalo lewat query, ya tinggal tulis saja query nya, lalu eksekusi
    itu pake GLOBAL
    artinya query tsb hanya bisa dijalankan oleh user yg punya hak modif variable GLOBAL
    yg pasti user root bisa eksekusi
    dan artinya jalan buat seluruh user dan session
    dan hanya berlaku selama mysql hidup
    kalo mysql di restart, ya seting itu kagak berlaku lagi
  • Siip paham master

    SET GLOBAL innodb_fast_shutdown=1; di query
    stop mysqld
    remove / rename ib_logfile0 & ib_logfile1
    edit value innodb_log_file_size
    kemudian start mysqld lagi...

    Terimakasih pencerahannya master...



    ^:)^ ^:)^ ^:)^ ^:)^
Sign In or Register to comment.