MRatWork Forum by Mustafa Ramadhan - Mysql ngadat

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, 23:20:17

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Mysql ngadat

« previous next »

- Print

Pages: [1] 2 Go Down

### Author Topic: Mysql ngadat (Read 4466 times)

0 Members and 1 Guest are viewing this topic.

#### ar1246

- Senior Member
- Posts: 234
- Karma: +0/-0
- Gender:

##### Mysql ngadat

« on: 2014-11-02, 12:15:47 »
pak mysql ngadat knp yah
waktu restart:
Code: [Select]

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

sya cleanup jg ky gt
udah upcp bahkan upcp -y tetep
ni pas upcp -y ada yg gini:
Code: [Select]

    >>> Creating Vpopmail database <<<
    Using qmail-toaster - fix '/home/vpopmail/etc/vpopmail.mysql'
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    >>> Fixing Vpopmail settings <<<
    >>> Preparing 'defaults' paths <<<
    >>> Setup default configure for Webserver <<<

    Create mysql.sock...
    Stopping mysqld:                                           [  OK  ]
    MySQL Daemon failed to start.
    Starting mysqld:                                           [FAILED]
    >>> Copy Kloxo-MR service init <<<

Code: [Select]

    [root@serv3 script]# sh reset-mysql-root-password
    Stop MySQL service...
    MySQL ROOT password reset...
    Start MySQL service...
    Connect failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Code: [Select]

    A. Kloxo-MR: 7.0.0.b-2014110202

    B. OS: CentOS release 6.6 (Final) i686

    C. Apps:
       1. MySQL: mysql55-5.5.40-1.ius.el6.i686
       2. PHP: php53u-5.3.29-1.ius.el6.i686
       3. Httpd: httpd-2.2.29-1.mr.el6.i386
       4. Lighttpd: --uninstalled--
       5. Hiawatha: hiawatha-9.8.0-f.2.mr.el6.i386
       6. Nginx: --uninstalled--
       7. Cache: --uninstalled--
       8. Dns: bind-9.9.5-1.el6.i686
       9. Qmail: qmail-toaster-1.03-1.3.38.mr.el6.i386
          - with: courier-imap-toaster-4.1.2-1.3.16.mr.el6.i386

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

    E. Memory:
                    total       used       free     shared    buffers     cached
       Mem:          1006        401        604          0         31        181
       -/+ buffers/cache:        188        817
       Swap:          255          0        255

Logged

#### MRatWork

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

##### Re: Mysql ngadat

« Reply #1 on: 2014-11-02, 21:31:59 »
Ini terjadi karena install baru atau karena update?.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### ar1246

- Senior Member
- Posts: 234
- Karma: +0/-0
- Gender:

##### Re: Mysql ngadat

« Reply #2 on: 2014-11-02, 21:49:57 »
update pak
stelah cleanup, tapi proses cleanup interupted
d ulangi lg jd gini.
Pak, kan d situ erornya di "/var/lib/mysql/mysql.sock yah"
saya cek di /var/lib/mysql/ gak ada file mysql.sock
saya baca" apakah benar katanya file mysql.sock itu auto generate ketika mysql aktif, dan ilang ketika mysql off?
apakan di folder permisionnya /var/lib/mysql/ pak penyebabnya?
Logged

#### MRatWork

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

##### Re: Mysql ngadat

« Reply #3 on: 2014-11-02, 22:20:23 »
Sejujurnya saya tidak tahu penyebab sebenarnya. Hanya saya tahu solusinya:
1. Jika pakai OpenVZ, pastikan ada 'innodb_use_native_aio=0' di bawah '[mysqld]'. Pastikan directory /var/lib/mysqltmp ada
2. Jika cara 1 tidak mempan, coba copy /usr/share/mysql/my-small.cnf atau my-medium.cnf atau my-large.cnf ke /etc/my.cnf (dengan memperhatikan cara 1)
3. Jika berhasil lakukan 'sh /script/mysql-convert --engine=myisam'
« Last Edit: 2014-11-02, 22:21:59 by MRatWork »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### ar1246

- Senior Member
- Posts: 234
- Karma: +0/-0
- Gender:

##### Re: Mysql ngadat

« Reply #4 on: 2014-11-02, 22:35:04 »
saya pake kvm pak
cara cek 'innodb_use_native_aio=0' di bawah '[mysqld]' gmn pak?
Logged

#### MRatWork

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

##### Re: Mysql ngadat

« Reply #5 on: 2014-11-02, 22:56:08 »
Ya, lihat saja isi /etc/my.cnf. Hanya OpenVZ yang perlu 'innodb_use_native_aio=0'
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### ar1246

- Senior Member
- Posts: 234
- Karma: +0/-0
- Gender:

##### Re: Mysql ngadat

« Reply #6 on: 2014-11-03, 02:23:11 »
maaf nih pak dasar bgt nanyanya, takut salah
ini /etc/my.cnf
Code: [Select]

    ##  _______________________________________________________________________
    ## / 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]
    skip-innodb
    default-storage-engine=myisam
    #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
    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

    ## 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

    open-files-limit                = 65535

    [mysql]
    no-auto-rehash

nah ini my-large.conf
Code: [Select]

    # The following options will be passed to all MySQL clients
    [client]
    #password       = your_password
    port            = 3306
    socket          = /var/lib/mysql/mysql.sock

    # Here follows entries for some specific programs

    # The MySQL server
    [mysqld]
    port            = 3306
    socket          = /var/lib/mysql/mysql.sock
    skip-external-locking
    key_buffer_size = 256M
    max_allowed_packet = 1M
    table_open_cache = 256
    sort_buffer_size = 1M
    read_buffer_size = 1M
    read_rnd_buffer_size = 4M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    query_cache_size= 16M
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency = 8

    # Don't listen on a TCP/IP port at all. This can be a security enhancement,
    # if all processes that need to connect to mysqld run on the same host.
    # All interaction with mysqld must be made via Unix sockets or named pipes.
    # Note that using this option without enabling named pipes on Windows
    # (via the "enable-named-pipe" option) will render mysqld useless!

    #
    #skip-networking

    # Replication Master Server (default)
    # binary logging is required for replication
    log-bin=mysql-bin

    # binary logging format - mixed recommended
    binlog_format=mixed

    # required unique id between 1 and 2^32 - 1
    # defaults to 1 if master-host is not set
    # but will not function as a master if omitted
    server-id       = 1

    # Replication Slave (comment out master section to use this)
    #
    # To configure this host as a replication slave, you can choose between
    # two methods :
    #
    # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
    #    the syntax is:
    #
    #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
    #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
    #
    #    where you replace <host>, <user>, <password> by quoted strings and
    #    <port> by the master's port number (3306 by default).
    #
    #    Example:
    #
    #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
    #    MASTER_USER='joe', MASTER_PASSWORD='secret';
    #
    # OR
    #
    # 2) Set the variables below. However, in case you choose this method, then
    #    start replication for the first time (even unsuccessfully, for example
    #    if you mistyped the password in master-password and the slave fails to
    #    connect), the slave will create a master.info file, and any later
    #    change in this file to the variables' values below will be ignored and
    #    overridden by the content of the master.info file, unless you shutdown
    #    the slave server, delete master.info and restart the slaver server.
    #    For that reason, you may want to leave the lines below untouched
    #    (commented) and instead use CHANGE MASTER TO (see above)
    #
    # required unique id between 2 and 2^32 - 1
    # (and different from the master)
    # defaults to 2 if master-host is set
    # but will not function as a slave if omitted
    #server-id       = 2
    #
    # The replication master for this slave - required
    #master-host     =   <hostname>
    #
    # The username the slave will use for authentication when connecting
    # to the master - required
    #master-user     =   <username>
    #
    # The password the slave will authenticate with when connecting to
    # the master - required
    #master-password =   <password>
    #
    # The port the master is listening on.
    # optional - defaults to 3306
    #master-port     =  <port>
    #
    # binary logging - not required for slaves, but recommended
    #log-bin=mysql-bin

    # Uncomment the following if you are using InnoDB tables
    #innodb_data_home_dir = /var/lib/mysql
    #innodb_data_file_path = ibdata1:10M:autoextend
    #innodb_log_group_home_dir = /var/lib/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 = 256M
    #innodb_additional_mem_pool_size = 20M
    # Set .._log_file_size to 25 % of buffer pool size
    #innodb_log_file_size = 64M
    #innodb_log_buffer_size = 8M
    #innodb_flush_log_at_trx_commit = 1
    #innodb_lock_wait_timeout = 50

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates

    [myisamchk]
    key_buffer_size = 128M
    sort_buffer_size = 128M
    read_buffer = 2M
    write_buffer = 2M

    [mysqlhotcopy]
    interactive-timeout

maksudnya di copy itu di gabung pak dari baris terakhir my.conf nya ato di replace?
saya sudah coba di gabung tapi gk ada kemajuan, masih eror
Logged

#### MRatWork

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

##### Re: Mysql ngadat

« Reply #7 on: 2014-11-03, 03:51:32 »
Replace.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### ar1246

- Senior Member
- Posts: 234
- Karma: +0/-0
- Gender:

##### Re: Mysql ngadat

« Reply #8 on: 2014-11-03, 08:13:37 »
masih blom bisa pak
Logged

#### MRatWork

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

##### Re: Mysql ngadat

« Reply #9 on: 2014-11-03, 10:07:40 »
Coba periksa /var/log/mysqld.log. Bisa terlihat kira-kira apa penyebabnya.
Tapi, infokan 'yum list installed mysql*'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### ar1246

- Senior Member
- Posts: 234
- Karma: +0/-0
- Gender:

##### Re: Mysql ngadat

« Reply #10 on: 2014-11-03, 17:54:56 »
yum list installed mysql*
Code: [Select]

    [root@serv3 ~]# yum list installed mysql*
    Loaded plugins: fastestmirror, priorities, protectbase, replace
    Loading mirror speeds from cached hostfile
    mratwork-epel/metalink                                   |  14 kB     00:00
     * base: mirrors.cat.pdx.edu
     * extras: mirrors.usinternet.com
     * mratwork-epel: ftp.osuosl.org
     * mratwork-ius-stable: ord.mirror.rackspace.com
     * updates: mirrors.cat.pdx.edu
    base                                                     | 3.7 kB     00:00
    extras                                                   | 3.3 kB     00:00
    mratwork-google-mod-pagespeed                            |  951 B     00:00
    mratwork-ius-archive                                     | 2.2 kB     00:00
    mratwork-ius-stable                                      | 2.1 kB     00:00
    mratwork-ius-stable/primary_db                           | 154 kB     00:00
    mratwork-litespeed                                       | 2.9 kB     00:00
    mratwork-litespeed/primary_db                            | 157 kB     00:00
    mratwork-litespeed-update                                |  951 B     00:00
    mratwork-nginx                                           | 2.9 kB     00:00
    mratwork-nginx-stable                                    | 2.9 kB     00:00
    mratwork-release-neutral-noarch                          |  951 B     00:00
    mratwork-release-version-arch                            |  951 B     00:00
    mratwork-varnish-3.0                                     |  951 B     00:00
    updates                                                  | 3.4 kB     00:00
    0 packages excluded due to repository protections
    Installed Packages
    mysql55.i686                   5.5.40-1.ius.el6             @mratwork-ius-stable
    mysql55-libs.i686              5.5.40-1.ius.el6             @mratwork-ius-stable
    mysql55-server.i686            5.5.40-1.ius.el6             @mratwork-ius-stable
    mysqlclient16.i686             5.1.61-4.ius.el6             @mratwork-ius-stable

log
Code: [Select]

    140927 22:33:15 mysqld_safe Starting mysqld daemon with databases from /var/lib$
    140927 22:33:15 [Warning] option 'relay_log_space_limit': unsigned value 171798$
    140927 22:33:15 [Note] Plugin 'FEDERATED' is disabled.
    140927 22:33:15 InnoDB: The InnoDB memory heap is disabled
    140927 22:33:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140927 22:33:15 InnoDB: Compressed tables use zlib 1.2.3
    140927 22:33:15 InnoDB: Initializing buffer pool, size = 128.0M
    140927 22:33:15 InnoDB: Completed initialization of buffer pool
    140927 22:33:15 InnoDB: highest supported file format is Barracuda.
    140927 22:33:15  InnoDB: Waiting for the background threads to start
    140927 22:33:16 InnoDB: 5.5.39 started; log sequence number 1595675
    140927 22:33:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140927 22:33:16 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140927 22:33:16 [Note] Server socket created on IP: '0.0.0.0'.
    140927 22:33:16 [Warning] 'user' entry 'root@serv3.arif.awalud.in' ignored in -$
    140927 22:33:16 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 22:33:16 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 22:33:16 [Note] Event Scheduler: Loaded 0 events
    140927 22:33:16 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.39'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Distributed$
    140927 22:46:12 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 22:46:12 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 22:46:12 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 22:46:13 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 22:46:13 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 22:46:13 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 22:46:13 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 22:46:13 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 22:46:13 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 22:49:36 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 22:49:36 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 22:49:36 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 22:49:37 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 22:49:37 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 22:49:37 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 22:49:50 [Note] /usr/libexec/mysqld: Normal shutdown

    140927 22:49:50 [Note] Event Scheduler: Purging the queue. 0 events
    140927 22:49:50  InnoDB: Starting shutdown...
    140927 22:49:50  InnoDB: Shutdown completed; log sequence number 1595675
    140927 22:49:50 [Note] /usr/libexec/mysqld: Shutdown complete

    140927 22:49:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid end$
    140927 22:49:51 mysqld_safe Starting mysqld daemon with databases from /var/lib$
    140927 22:49:51 [Warning] option 'relay_log_space_limit': unsigned value 171798$
    140927 22:49:51 [Note] Plugin 'FEDERATED' is disabled.
    140927 22:49:51 InnoDB: The InnoDB memory heap is disabled
    140927 22:49:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140927 22:49:51 InnoDB: Compressed tables use zlib 1.2.3
    140927 22:49:51 InnoDB: Initializing buffer pool, size = 128.0M
    140927 22:49:51 InnoDB: Completed initialization of buffer pool
    140927 22:49:51 InnoDB: highest supported file format is Barracuda.
    140927 22:49:51  InnoDB: Waiting for the background threads to start
    140927 22:49:52 InnoDB: 5.5.39 started; log sequence number 1595675
    140927 22:49:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140927 22:49:52 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140927 22:49:52 [Note] Server socket created on IP: '0.0.0.0'.
    140927 22:49:52 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 22:49:52 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 22:49:52 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 22:49:52 [Note] Event Scheduler: Loaded 0 events
    140927 22:49:52 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.39'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Distributed$
    140927 23:01:22 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 23:01:22 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 23:01:22 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 23:01:24 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 23:01:24 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 23:01:24 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 23:04:36 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 23:04:36 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 23:04:36 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 23:04:37 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 23:04:37 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 23:04:37 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 23:07:19 [Note] /usr/libexec/mysqld: Normal shutdown

    140927 23:07:19 [Note] Event Scheduler: Purging the queue. 0 events
    140927 23:07:21 [Warning] /usr/libexec/mysqld: Forcing close of thread 1362  us$

    140927 23:07:21 [Warning] /usr/libexec/mysqld: Forcing close of thread 1361  us$

    140927 23:07:21 [Warning] /usr/libexec/mysqld: Forcing close of thread 17  user$

    140927 23:07:21 [Warning] /usr/libexec/mysqld: Forcing close of thread 16  user$

    140927 23:07:21  InnoDB: Starting shutdown...
    140927 23:07:21  InnoDB: Shutdown completed; log sequence number 1595675
    140927 23:07:21 [Note] /usr/libexec/mysqld: Shutdown complete

    140927 23:07:21 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid end$
    140927 23:07:23 mysqld_safe Starting mysqld daemon with databases from /var/lib$
    140927 23:07:23 [Warning] option 'relay_log_space_limit': unsigned value 171798$
    140927 23:07:23 [Note] Plugin 'FEDERATED' is disabled.
    140927 23:07:23 InnoDB: The InnoDB memory heap is disabled
    140927 23:07:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140927 23:07:23 InnoDB: Compressed tables use zlib 1.2.3
    140927 23:07:23 InnoDB: Initializing buffer pool, size = 128.0M
    140927 23:07:23 InnoDB: Completed initialization of buffer pool
    140927 23:07:23 InnoDB: highest supported file format is Barracuda.
    140927 23:07:23  InnoDB: Waiting for the background threads to start
    140927 23:07:24 InnoDB: 5.5.39 started; log sequence number 1595675
    140927 23:07:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140927 23:07:24 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140927 23:07:24 [Note] Server socket created on IP: '0.0.0.0'.
    140927 23:07:24 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 23:07:24 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 23:07:24 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 23:07:24 [Note] Event Scheduler: Loaded 0 events
    140927 23:07:24 [Note] Event Scheduler: Loaded 0 events
    140927 23:07:24 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.39'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Distributed$
    140927 23:33:01 mysqld_safe Starting mysqld daemon with databases from /var/lib$
    140927 23:33:01 [Warning] option 'relay_log_space_limit': unsigned value 171798$
    140927 23:33:01 [Note] Plugin 'FEDERATED' is disabled.
    140927 23:33:01 InnoDB: The InnoDB memory heap is disabled
    140927 23:33:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140927 23:33:01 InnoDB: Compressed tables use zlib 1.2.3
    140927 23:33:01 InnoDB: Initializing buffer pool, size = 128.0M
    140927 23:33:01 InnoDB: Completed initialization of buffer pool
    140927 23:33:01 InnoDB: highest supported file format is Barracuda.
    140927 23:33:02  InnoDB: Waiting for the background threads to start
    140927 23:33:03 InnoDB: 5.5.39 started; log sequence number 1595675
    140927 23:33:03 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140927 23:33:03 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140927 23:33:03 [Note] Server socket created on IP: '0.0.0.0'.
    140927 23:33:03 [Warning] 'user' entry 'root@serv3.a**********lud.in' ignored in -$
    140927 23:33:03 [Warning] 'user' entry '@serv3.a**********lud.in' ignored in --ski$
    140927 23:33:03 [Warning] 'proxies_priv' entry '@ root@serv3.a**********lud.in' ig$
    140927 23:33:03 [Note] Event Scheduler: Loaded 0 events
    140927 23:33:03 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.39'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Distributed$
    140928  0:39:40 [Note] /usr/libexec/mysqld: Normal shutdown

    140928  0:39:40 [Note] Event Scheduler: Purging the queue. 0 events
    140928  0:39:40  InnoDB: Starting shutdown...
    140928  0:39:40  InnoDB: Shutdown completed; log sequence number 1595675
    140928  0:39:40 [Note] /usr/libexec/mysqld: Shutdown complete

    140928 00:39:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid end$
    140928 00:39:41 mysqld_safe Starting mysqld daemon with databases from /var/lib$
    140928  0:39:41 [Warning] option 'relay_log_space_limit': unsigned value 171798$
    140928  0:39:41 [Note] Plugin 'FEDERATED' is disabled.
    140928  0:39:41 InnoDB: The InnoDB memory heap is disabled
    140928  0:39:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140928  0:39:41 InnoDB: Compressed tables use zlib 1.2.3

Logged

#### MRatWork

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

##### Re: Mysql ngadat

« Reply #11 on: 2014-11-03, 19:12:08 »
Beri saya akses ke ssh dan Kloxo-MR panel anda. Kirim via PM.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### ar1246

- Senior Member
- Posts: 234
- Karma: +0/-0
- Gender:

##### Re: Mysql ngadat

« Reply #12 on: 2014-11-04, 02:33:46 »
udah saa kirim pm nya pak
Logged

#### ar1246

- Senior Member
- Posts: 234
- Karma: +0/-0
- Gender:

##### Re: Mysql ngadat

« Reply #13 on: 2014-11-05, 04:59:49 »
Terima kasih banyak pak pertolongannya
masalah barunya yg d dns bind agak aneh juga pak, sesuai rekomendasi saya switch dns ke beberapa dns lain tapi muncul alert : remove bind failed
knapa yah pak?
Logged

#### MRatWork

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

##### Re: Mysql ngadat

« Reply #14 on: 2014-11-05, 10:06:06 »
Coba saja secara manual dilakukan 'yum remove bind*' dan kemudian dari panel lakukan pergantian dns server.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

- Print

Pages: [1] 2 Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Mysql ngadat

MRatWork Affiliates: BIGRAF(R) Inc. House of LMAR EFARgrafix

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

Page created in 0.042 seconds with 17 queries.

Mirror created by MasterkinG32.CoM