Mysql ngadat

[ar1246]

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


[MRatWork]

Ini terjadi karena install baru atau karena update?.

[ar1246]

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?

[MRatWork]

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'

[ar1246]

saya pake kvm pak
cara cek  'innodb_use_native_aio=0' di bawah '[mysqld]' gmn pak?

[MRatWork]

Ya, lihat saja isi /etc/my.cnf. Hanya OpenVZ yang perlu 'innodb_use_native_aio=0'

[ar1246]

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 

[MRatWork]

Replace.

[ar1246]

masih blom bisa pak

[MRatWork]

Coba periksa /var/log/mysqld.log. Bisa terlihat kira-kira apa penyebabnya.

Tapi, infokan 'yum list installed mysql*'.

[ar1246]

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



[MRatWork]

Beri saya akses ke ssh dan Kloxo-MR panel anda. Kirim via PM.

[ar1246]

udah saa kirim pm nya pak

[ar1246]

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?

[MRatWork]

Coba saja secara manual dilakukan 'yum remove bind*' dan kemudian dari panel lakukan pergantian dns server.