Stack Overflow
Stack Overflow

Questions tagged [binary-log]

40 questions
2
votes
1 answer

Mysql data recovery using mysqlbinlog

I accidentally dropped a schema without backing it up. And now I want to use mysqlbinlog utility to perform recovery. (It seems that mysqlbinlog is a good tool). And it needs those binary log files to perform recovery. Now I have the following…
xiaohan2012
  • 9,870
  • 23
  • 67
  • 101
2
votes
1 answer

SELECT queries in MySQL binary_log

I am trying to verify database histories. For that, I need to log and parse read-write accesses to a database. I know MySQL mainly offers two types of logs - general query log and binary log. General query log is not helpful for me since it does not…
rnbguy
  • 1,369
  • 1
  • 10
  • 28
2
votes
0 answers

MySQL binary logs will not start

In-Short: My binary logs aren't starting even though log-bin is set and specified. I'm not sure how to fix it. I have a MariaDB instance running as a service on windows that I am attempting to replicate to a MariaDB instance on a Ubuntu machine. I…
Ubunfu
  • 1,083
  • 2
  • 10
  • 21
2
votes
3 answers

Is it possible to have separate binary logs per database in mysql?

I am looking at a replicated system that replicates four different databases to a bunch of slaves. I am having a problem that one application/database is running some big queries that are holding up replication in the other databases. Obviously I am…
Ben Holness
  • 2,457
  • 3
  • 28
  • 49
1
vote
1 answer

run trigger without writing to binary log

I'm trying to insert rows into a table via a trigger or stored procedure without writing any data to the binary log. Is this possible? I know that for normal connections you can set SQL_LOG_BIN=0 to disable binary logging for the connection, but I…
A B
  • 8,340
  • 2
  • 31
  • 35
1
vote
1 answer

AWS RDS MySQL is it safe to change binary logging settings

I need to change few settings in RDS MySQL parameter group. I was wondering if it's safe to perform these changes or should I take a preventive approach ? Here's the parameters I need to change: binlog_checksum = none binlog_row_image =…
AlexBrunet
  • 85
  • 8
1
vote
1 answer

Google CloudSQL Max Binary Log Size

Setting the value for max_binlog_size doesn't seem to be a supported flag in CloudSQL 2nd Generation MySQL instances. On provisioning a new instance, I can see from running show variables; that max binlog size is set as…
Molenpad
  • 833
  • 2
  • 14
  • 34
1
vote
1 answer

What is "table_id" in MySQL binary log events?

Is there any description for table_id in MySQL binary log events? Is it a unique value?
Udara Gunathilake
  • 202
  • 1
  • 2
  • 14
1
vote
1 answer

When is the timestamp set in MySQL binlogs

I've had a search through previous questions but can't find an exact match to my question: At what point during a query transaction is the binary log timestamp set and then written to the binary log? Context: I have been working with a DB which is…
Nicholas Rhodes
  • 135
  • 1
  • 6
1
vote
0 answers

How replicate-ignore-db OR replicate-ignore-table works internally?

In MySQL replication we have replication filters: replicate-ignore-db replicate-ignore-table These filters are used to ignore the database / table to replication on slave server. During the creation of relay log, slave server check the rules and…
Aman Aggarwal
  • 17,619
  • 9
  • 53
  • 81
1
vote
1 answer

mysql: need to avoid storing temp tables on binary logs

On mysql, I have two data bases "parque_test" and "tabelas_temporais", and binary logs are activated. Every action that modifies an InnoDB table belonging to "parque_test" is recorded on the binary log. However, "parque_test" has stored procedures…
user3889486
  • 656
  • 1
  • 7
  • 21
1
vote
2 answers

Binary logging in MySQL

Here is my.ini # Replication Master Server (default) # binary logging is required for replication log-bin=mysql-bin I'm trying to binary logging of mysql database. Please suggest me to enable binary logging in MySQL Version 5.5.16
lnepal
  • 549
  • 8
  • 20
1
vote
1 answer

Binary logarithm in O(1) time (operating on registers x86 or SIMD) without shifting?

I wanted to see if there is a method for finding the binary log of a number. Say you have the number 4 then the power to which you raise two to get four is 2. I know this is possible with shifting and counting but that uses O(N) operations. Is there…
pandoragami
  • 5,387
  • 15
  • 68
  • 116
1
vote
3 answers

MySQL query based replication

I wish to road-test a MySQL Cluster instance by passing it all query which are executed on InnoDB MySQL instance. I'm not too worried about data integrity on the Cluster at present, this study is focused on the stability and speed of the Cluster. I…
user177765
0
votes
1 answer

MySQL - saving binary log to table by default

I am using MySQL Community Server 5.1. I remember a while back I heard that it was possible to configure MySQL database to save the binary log information to a MySQL table. I did a brief search and didn't come back with what I was looking for this…
jeffery_the_wind
  • 17,048
  • 34
  • 98
  • 160
1
2
3