The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
2answers
16 views

Partial mysqlbinlog on latest binlog file

I'm trying to do a partial mysqlbinlog on the latest binary log file at a certain position therein (trying to extract just one query). mysqlbinlog --start-position=1234 --stop-position=1234 ...
1
vote
1answer
277 views

mysql replication missed quite a lot SQL statement

I have set up a master/slave with mysql-5.1.73 The master's binlog format is "statement". The master and slave seemed running very well with slave status: Slave_IO_Running: Yes ...
1
vote
1answer
25 views

Changing tx_isolation and binlog format on master server - do i also need to adjust slave?

We are running a Drupal Commerce site with MariaDB 10.0 and master/slave replication. Because of the way our application works, we end up running in to a ton of deadlocks under heavy load. Apparently ...
1
vote
1answer
488 views

How to set selinux permission for non-standard mysql bin log path?

By default, mysql bin log works in folder /var/log/mysql. but moving to any other share such /mylogs/mysql gives permission error. Below is the exact message: usr/sbin/mysqld: File ...
0
votes
0answers
10 views

Using MySQL bin logger to log a table insert with join

I am using Maxwell to listen to MySQL bin logger and it is working perfectly fine. I am able to listen to insert queries but i was wondering if i can get columns of the foreign keys ( i.e join)? I ...
1
vote
2answers
235 views

MySQL binary logging with just one log file?

I have a MySQL database running with binary logging turned on. Each time the database is restarted a new binary log file is created in the format : mysql-bin.00001 mysql-bin.00002 ... mysql-bin.0000n ...
0
votes
2answers
51 views

Mysql FLUSH LOGS in live server with replication

I need to run the slow query and unindexed query logging for some time on a live production db with replication. Changing GLOBAL const value sounds like a good solution. This article also provides ...
0
votes
2answers
560 views

Abnormally high MySQL writes and larger than normal Binary Log files. How can I determine what caused this?

We have a MySQL master database which replicates to a MySQL slave. We were experiencing issues where MySQL was showing a high number of writes (but not an increased number of queries being ran) for a ...
0
votes
0answers
39 views

MySql master stopped writing to binlogs when tmp partition full

Percona MySql version is : mysql Ver 14.14 Distrib 5.5.46-37.5, for debian-linux-gnu (x86_64) using readline 5.1 OS Version is : Debian 7.9 MySql master has a separate tmp partition, of ...
3
votes
1answer
1k views

MySQL Master-Master Replication not syncing

SETUP: I have a WAMP MySQL Master-Master replication setup on 2 machines with sync_binlog=1 for safety. Machine config: Windows Azure Standard 2: 2 core, 4GB RAM, Windows Server 2008, MySQL 5.6.12, ...
0
votes
1answer
22 views

Mysql datadir and binlogs: same partition or not?

On a MySQL cluster, does it make sense to store MySQL database files and binlogs in different partitions? (This is about partitions on the same physical disk. If they were on different physical ...
0
votes
1answer
40 views

mixing binlog formats between master and slave

I have a pretty much straightforward Master --> Slave replication setup in MySQL 5.6 / Innodb. Both my Master and Slave are setup in MIXED binlog format. Now I need my slave to act as a master to ...
1
vote
1answer
188 views

mysql max_binlog_size is not working

I have a weird problem. I am currently using mysql and have defined 100M of max_binlog_size. However, I have hundreds of files created every day and each file is of no more then 2MB or 3MB each and ...
1
vote
1answer
85 views

MySQL binlog does not show SQL statements

While checking the binlogs, it struck me that I cannot see any SQL statement. Here's an example: $> sudo mysqlbinlog --database=securities --start-datetime='2015-11-26 13:00:00' ...
2
votes
1answer
196 views

MySQL: Why statement-based binlog format cannot work with Innodb READ UNCOMMITTED or READ COMMITTED Isolation levels?

In MySQL documentation it's written: If you are using InnoDB tables and the transaction isolation level is READ COMMITTED or READ UNCOMMITTED, only row-based logging can be used. Why ...
7
votes
4answers
17k views

Disable MySQL binary logging with log_bin variable

Default MySQL config file /etc/mysql/my.cnf installed by some debian package using APT often set log_bin variable, so binlog are enabled: log_bin = /var/log/mysql/mysql-bin.log When I want to ...
1
vote
1answer
721 views

How can I parse mysql bin log file for statements (Row/Mixed Format)

I have a mysql database running with binary log enabled. Unfortunately, a statement was executed by the client, which turned out erroneous. Since a number of records have been "affected", I want to ...
0
votes
1answer
42 views

Suddenly a massive amount of binlog files

I've seen a sudden increase of binlog files, very large in number and size, in all three nodes of a Percona XtraDB cluster: -rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:11 binlog-32.000001 -rw-rw---- ...
0
votes
0answers
87 views

Mysql server does not start if binary logging is disabled

I have been trying to disable binary logging on a slave server, since I do not use it as a master for another one, I have no use for the logs and I am trying to reduce lag so cut out everything that ...
5
votes
1answer
3k views

Binlog has bad magic number

I keep getting this error whenever I start MySQL. 121028 1:38:55 [Note] Plugin 'FEDERATED' is disabled. 121028 1:38:55 InnoDB: The InnoDB memory heap is disabled 121028 1:38:55 InnoDB: Mutexes and ...
0
votes
1answer
92 views

mysqlbinlog: unknown variable ssl_key or ssl_cert or ssl_ca

I am trying to recover binlog from a remote server using mysqlbinlog client program, however it appears that mysqlbinlog doesn't recognize the SSL options that's required to establish SSL connect to ...
1
vote
1answer
600 views

How to track only DDL statements executed in MySQL

Can we track only executed DDL statements in MySQL but not DML statements. I dont want to use either binlog/general log to enable. I just wanted to track only DDL statements. I had gone through the ...
0
votes
0answers
11 views

Binlogs in MySQL are created too frequently, how to solve this issue?

We are using MYISAM storage engine in a Master-Master replication environment. The number of binlogs which is to be generated regularly is getting very high count despite setting binlog size of 1.6GB, ...
0
votes
1answer
35 views

Unable to show binary logs how to remove logs from mysql?

Server version: 5.1.50-log MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show binary logs ; PROBLEM Data directory is full I want to remove ...
3
votes
1answer
290 views

MySQL v5.1.73 - can the binlog_format betweem Master & slave be different?

We are in the process of testing MySQL replication before using it in production. The MySQL is being setup by Puppet in our case and I noticed that the binlog_format setting is different between ...
1
vote
1answer
118 views

How to determine if a mysql binary log file is empty?

In order to determine whether a database backup is needed or not, I'm trying to see whether a mysql binlog file has any data in it. (During a backup, we make a fresh binlog file and record the ...
1
vote
1answer
42 views

MySQL: Incorrect binary log format - OFF.000

I have a Percona MySQL 5.5.30 as a master(Debian 6.0.7). I got a weird issue that all my binary logs started saving in format OFF.00* instead of the specified format in .cnf file. mysql> show ...
0
votes
1answer
89 views

Why binlog capture only postions

Please help me out, why master server records only position not statement. ### INSERT INTO `sanma`.`response` ### SET ### @1=743096223 ### @2=0 ### @3='IR' ### @4='UnderProcess' ### ...
0
votes
1answer
133 views

MySQL binlog limitations

I have a MySQL instance running on AWS, with around 5000 inserts per second. Any idea what the performance impact will be if I use binlog (row) and a binlog tailer? Check this link From my ...
1
vote
2answers
164 views

Why is restoration from binary logs so slow?

We have a MySQL 5.5 server with binary logging enabled and a backup script that collects the binary logs and, once a day, generates a complete database dump with mysqldump. In testing database ...
0
votes
1answer
142 views

MySQL Crash After Starting Binary Logs

Recently I have added binary logs to mysql to start replication but after that setting, mysql process failed to start and keep crashing constantly. In mysql error logs some messages are there but not ...
0
votes
1answer
984 views

Hi disk I/O and crash when turning on sync_binlog in MySQL

I have a MySQL master server (MariaDB 10.0.17) that have a very odd behavior. It has one slave fetching data from it. When I set global sync_binlog = 1, the server I/O goes very high and after some ...
2
votes
2answers
438 views

MySQL 5.6 Slave Stops Processing Binlog on Master Restart

I have a pair of Debian 7 servers with MySQL 5.6.23. The slave server is a clone of the master (but the uuid has been regenerated on the slave). For some reason, whenever MySQL is restarted on the ...
0
votes
1answer
85 views

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again?

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again ? I know the below points exist means, there won't be any reset happen in binlogs. I ...
1
vote
1answer
98 views

Purge mysql log bins older than two weeks automatically

I have to manually write purge binary logs bin to "mysql-bin.somenumbers" ; Once in a while, I need to reduce the spaces that binlogs are taking on my web server. Is it possible to purge binary ...
1
vote
1answer
1k views

Mysql binlogs exists, show binary logs is empty

I am working on a replication setup and have turned on bin-logs. I have moved my mysql datadir to a new location as well as the binlog path From my.cnf datadir = /vol/data/mysql ...
7
votes
3answers
19k views

Why do the MySQL bin log files still exist after a purge or flush?

I've used PURGE BINARY LOGS as well as FLUSH LOGS, but the mysql directory still contains these files: mysql-bin.000025 mysql-bin.000024 mysql-bin.000023 mysql-bin.000022 mysql-bin.000021 ...
1
vote
1answer
113 views

Binlog not consistent between slave and master

Initially I don't see binlog on slave is updating. Today I discovered and add log-slave-updates option to slave, now it is updating. However, the filename does not match between slave and master. ...
3
votes
1answer
1k views

pt-table-checksum and row-based replication

The set up I work with is MySQL 5.5 in a master-slave replication configuration, but we have to use "MIXED" replication (statement and row-based) because we use an application that requires it, and it ...
0
votes
1answer
2k views

MySQL row-based-replication HA_ERR_KEY_NOT_FOUND… which record is it?

I have a mysql slave (5.1) using row-based replication. The slave has stopped with the error HA_ERR_KEY_NOT_FOUND. OK fine, it's trying to update a record that doesn't exist for some reason. Using the ...
4
votes
2answers
3k views

MySQL binary logs - skip a table

Is there a way to skip a specific table in the binary logs? I've got binary logs configured as my incremental backup strategy between nightly backups. But we have one huge reference table that we're ...
1
vote
2answers
512 views

MySQL : 30GB of binlogs in 6 Hours

I have a mysql master/master setup with tungsten replicator. My server is reaching out of space, occupied around 30G in 6 hours. I'm not sure how to handle this. Would be great if some one can help me ...
0
votes
1answer
560 views

why mysql binlog creating new log file daily

I have started binary logging on MySQL server on my Ubuntu. It start creating log files in /var/log/mysql. My my.cnf configuration is as follows: log-bin="/var/log/mysql/" expire_logs_days=10 ...
0
votes
1answer
894 views

Replication - Binary log parsing(Tableid generation, ON DELETE CASCADE handling, Changed columns for update event)

I am using MySQL 5.5 with InnoDB engine. I have set binlog format as row-based replication. I have some doubts regarding replication: 1) How is the tableID generated? Is it stored somewhere? 2) ...
0
votes
0answers
187 views

MySQL Slave with erratic Read_Master_Log_Pos during binlog rotation?

I have two mysql servers setup with default my.cnf config apart from server-id's and enabling binlogs on masters. Replication is setup and working and i have a simple bash scrip on master feeding in ...
0
votes
2answers
5k views

MySQL : Extract SQL statements from binlog

I am trying the following command to extract SQL statements from binlog for using it in another database (Amazon RDS) mysqlbinlog /var/lib/mysql/binlog.000027 --start-position=54375264 ...
2
votes
1answer
309 views

mysql binlog file size stop growing

I made a master(A)-slave(B)-slave(C) mode MySQL instances for backup. But today when I see whether the mode works fine, I find A and B are OK. That is B can get binlog from A, but B does not write ...
0
votes
1answer
781 views

Replication master binlog rotation when network is unavailable

I recently experienced an issue where the binlog file in master rotated because network connectivity between the slave and master was unavailable. After solving the network issue, the slave was not ...
1
vote
1answer
276 views

Master updates Slave but not Master itself

I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color. ...
3
votes
1answer
378 views

Switch MySQL lag slave to new master and keep lagging (5.1)

We have the following scenario: Set of slaves replicate from the master, separate standby master (a.k.a slave with binlogs) replicates from the same master; lag slave, powered by pt-slave-delay, ...