MRatWork Forum by Mustafa Ramadhan - serve error perlu direstart

Sponsor:
Server and Web Integrator
Link:
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:

MRatWork Forum | Please login or register. | 2017-11-07, 18:15:40

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- serve error perlu direstart

« previous next »

- Print

Pages: [1] Go Down

### Author Topic: serve error perlu direstart (Read 872 times)

0 Members and 1 Guest are viewing this topic.

#### julian

- Junior Member
- Posts: 7
- Karma: +0/-0

##### serve error perlu direstart

« on: 2017-01-20, 12:42:25 »
Saya menggunakan vps di digital ocean, kloxomr 6.5 dan wordpress untuk CMS nya
dalam seminggu 1-2x selalu mengalami error tidak dapat diakses
database error.....
sehingga tidak bisa login kedalam kloxonya walaupun login dan passwordnya benar.
yg saya lakukan adalah dengan ssh melakukan sh /script/restart-all
dan hasilnya normal kembali.
pertanyaanya kenapa ini sering terjadi dan bagaimana cara mengatasinya
terima kasih sebelumnya
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: serve error perlu direstart

« Reply #1 on: 2017-01-20, 12:44:51 »
Coba saja 'sh /script/mysql-optimize --select=repair'. Siapa tahu ada database yang error.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### julian

- Junior Member
- Posts: 7
- Karma: +0/-0

##### Re: serve error perlu direstart

« Reply #2 on: 2017-01-23, 04:03:47 »
terima kasih mas, saya coba dahulu. semoga tidak ada masalah lagi nantinya
Logged

#### julian

- Junior Member
- Posts: 7
- Karma: +0/-0

##### Re: serve error perlu direstart

« Reply #3 on: 2017-01-27, 05:47:21 »
sudah di repair dan masih error kembali mas
"Error Establishing a Database Connection"
dan saya sudah coba 'sh /script/cleanup' juga
setiap kali di reboot normal lagi, tapi dalam beberapa hari erro kembali
mohon masukkannya. terima kasih
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: serve error perlu direstart

« Reply #4 on: 2017-01-27, 05:55:15 »
Infokan 'sh /script/sysinfo; cat /etc/my.cnf'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### julian

- Junior Member
- Posts: 7
- Karma: +0/-0

##### Re: serve error perlu direstart

« Reply #5 on: 2017-01-27, 08:32:23 »
ini mas
Code: [Select]

    A. Kloxo-MR: 6.5.0.f-2016111301

    B. OS: CentOS release 6.8 (Final) x86_64

    C. Apps:
       1. MySQL: mysql55-5.5.54-1.ius.el6.x86_64
       2. PHP: php53u-5.3.29-1.ius.centos6.x86_64
       3. Httpd: httpd-2.2.31-1.mr.el6.x86_64
       4. Lighttpd: --uninstalled--
       5. Nginx: --uninstalled--
       6. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
          - with: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
       7. Dns: bind-9.9.7-1.mr.el6.x86_64

    D. Php-type (for Httpd/proxy):

    E. Memory:
                    total       used       free     shared    buffers     cached
       Mem:           490        439         51          0         10        174
       -/+ buffers/cache:        254        235
       Swap:            0          0          0

    ##  _______________________________________________________________________
    ## / Rackspace MySQL 5.5 Terse Configuration File                          \
    ## |                                                                       |
    ## | This is a base configuration file containing the most frequently used |
    ## | settings with reasonably defined default values for configuring and   |
    ## | tuning MySQL. Note that these settings can likely be further tuned in |
    ## | order to get optimum performance from MySQL based upon the database   |
    ## | configuration and hardware platform.                                  |
    ## |                                                                       |
    ## | While the settings provided are likely sufficient for most            |
    ## | situations, an exhaustive list of settings (with descriptions) can be |
    ## | found at:                                                             |
    ## | http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html   |
    ## |                                                                       |
    ## | Take care to only add/remove/change a setting if you are comfortable  |
    ## | doing so! For Rackspace customers, if you have any questions or       |
    ## | concerns, please contact the MySQL Database Services Team. Be aware   |
    ## | that some work performed by this team can involve additional billable |
    ## \ fees.                                                                 /
    ##  -----------------------------------------------------------------------
    ##         \   ^__^
    ##          \  (oo)\_______
    ##             (__)\       )\/\
    ##                 ||----w |
    ##                 ||     ||

    [mysqld]
    #OpenVZ AIO bug fix
    innodb_use_native_aio=0

    ## General
    datadir                         = /var/lib/mysql
    tmpdir                          = /var/lib/mysqltmp
    socket                          = /var/lib/mysql/mysql.sock
    skip-name-resolve
    sql-mode                        = NO_ENGINE_SUBSTITUTION
    #event-scheduler                = 1

    ## Cache
    thread-cache-size               = 16
    table-open-cache                = 4096
    table-definition-cache          = 2048
    query-cache-size                = 32M
    query-cache-limit               = 1M

    ## Per-thread Buffers
    sort-buffer-size                = 1M
    read-buffer-size                = 1M
    read-rnd-buffer-size            = 1M
    join-buffer-size                = 1M

    ## Temp Tables
    tmp-table-size                  = 32M
    max-heap-table-size             = 64M

    ## Networking
    back-log                        = 100
    #max-connections                = 200
    max-connect-errors              = 10000
    max-allowed-packet              = 16M
    interactive-timeout             = 3600
    wait-timeout                    = 600

    ### Storage Engines
    #default-storage-engine         = InnoDB
    innodb                          = FORCE

    ## MyISAM
    key-buffer-size                 = 64M
    myisam-sort-buffer-size         = 128M

    ## InnoDB
    #innodb-buffer-pool-size        = 128M
    #innodb-log-file-size           = 100M
    #innodb-log-buffer-size         = 8M
    #innodb-file-per-table          = 1
    #innodb-open-files              = 300

    ## Replication
    server-id                       = 1
    #log-bin                        = /var/log/mysql/bin-log
    #relay-log                      = /var/log/mysql/relay-log
    relay-log-space-limit           = 16G
    expire-logs-days                = 7
    #read-only                      = 1
    #sync-binlog                    = 1
    #log-slave-updates              = 1
    #binlog-format                  = STATEMENT
    #auto-increment-offset          = 1
    #auto-increment-increment       = 2

    ## Logging
    #log-output                      = FILE
    #slow-query-log                  = 1
    #slow-query-log-file             = /var/log/mysql/slow-log
    #log-slow-slave-statements
    #long-query-time                 = 2

    [mysqld_safe]
    log-error                       = /var/log/mysqld.log
    open-files-limit                = 65535

    [mysql]
    no-auto-rehash

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: serve error perlu direstart

« Reply #6 on: 2017-01-27, 09:57:33 »
Kelihatannya anda pakai innodb untuk mysql. Memang 'mysql-optimize' tidak bisa repair database jika pakai innodb. Hanya myisam atau aria storage-engine yang bisa.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### julian

- Junior Member
- Posts: 7
- Karma: +0/-0

##### Re: serve error perlu direstart

« Reply #7 on: 2017-01-27, 10:31:48 »
bagaimana solusi untuk memperbaikinya?
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: serve error perlu direstart

« Reply #8 on: 2017-01-27, 11:57:19 »
Wah, kalau innodb harus dilakukan proses backup-restore untuk databasenya.
Dalam banyak kasus, tidak perlu pakai innodb. Jika ingin pakai myisam perlu dilakukan convert dari innodb ke myisam. Baru kemudian dilakukan repair jika diperlukan.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

- Print

Pages: [1] Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- serve error perlu direstart

Top 4 Global Search Engines: Google Bing Baidu Yahoo

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.033 seconds with 17 queries.

Mirror created by MasterkinG32.CoM