MySQL Forums
Forum List  »  Replication

Re: mysqld-relay-bin files
Posted by: chandler s.
Date: March 17, 2017 06:15PM

Thanks Alexander.

The SHOW SLAVE STATUS command doesn't return anything (see below). The files are named mysqld-relay-bin.* for example, mysqld-relay-bin.000184. The name of the server isn't "mysqld" but that is one of the headings in the /etc/my.cnf (see below). As the SHOW SLAVE STATUS command didn't return anything, I'm unsure how to run the STOP SLAVE command.


# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.1.73-log Source distribution

mysql> SHOW SLAVE STATUS;
Empty set (0.00 sec)

mysql> Ctrl-C -- exit!
Aborted
# cat /etc/my.cnf
[mysqld]
datadir=/db/mysql
socket=/db/mysql/mysql.sock
user=mysql
symbolic-links=0
key_buffer = 16M
max_allowed_packet = 500M
thread_stack = 128K
thread_cache_size = 8
query_cache_limit = 1048576
query_cache_size = 16777216
query_cache_type = 1
log-error = /opt/log/mysql/mysql-err.log
#server-id = 1
log_bin = /opt/log/mysql/mysql-bin.log
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
innodb_file_per_table
innodb_log_file_size = 100M

[mysqldump]
quick
quote-names
max_allowed_packet = 1000M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
port = 3306
socket = /db/mysql/mysql.sock

Options: ReplyQuote


Subject
Views
Written By
Posted
6697
February 21, 2017 06:53PM
2694
March 10, 2017 08:05AM
Re: mysqld-relay-bin files
2176
March 17, 2017 06:15PM
1566
May 25, 2017 08:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.