Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: mysqlbinlog

pt-query-digest –type binlog (percona-toolkit) gives empty output with MariaDB/Galera 10.1

By adminPosted on January 24, 2023

Question : My installed versions of MariaDB and Percona Toolkit on MacBook: brew info percona-toolkit percona-toolkit: stable 3.0.10 (bottled), HEAD […]

MySQL : Extract SQL statements from binlog

By adminPosted on January 23, 2023

Question : I am trying the following command to extract SQL statements from binlog for using it in another database […]

what happens If I remove mysql-bin.index file?

By adminPosted on January 3, 2023

Question : Because of the file storage full, we are removing mysql bin log files. Accidentally, we removed mysql-bin.index file. […]

MySQL Error wth Relay logs – Could not open relay logs file for logging

By adminPosted on December 14, 2022

Question : We are receiving the following error. 2016-03-08 15:32:09 1184 [ERROR] MYSQL_BIN_LOG::move_crash_safe_index_file_to_index_file failed to move crash_safe_index_file to index file. […]

Can it be safe to disable binary logging in MySQL?

By adminPosted on November 17, 2022

Question : Is the MySQL binlog similar to Oracle’s redo log or PostgreSQL’s Write-Ahead Log? If yes, how come it […]

Broken Slave MySQL : How To Fix MySQL Replication (BINLOG) error in the Slave?

By adminPosted on October 20, 2022

Question : Before we start I can give some info about the versions, Ubuntu – 14.04, MySQL – 5.5 I […]

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

By adminPosted on September 29, 2022

Question : I’ve used PURGE BINARY LOGS as well as FLUSH LOGS, but the mysql directory still contains these files: […]

what happens If I remove mysql-bin.index file?

By adminPosted on September 26, 2022

Question : Because of the file storage full, we are removing mysql bin log files. Accidentally, we removed mysql-bin.index file. […]

How do I get the MySQL binary log coordinates from the binary files?

By adminPosted on September 21, 2022

Question : I’m attempting to set up replication for a large (120 GB) MySQL database and I messed up. I […]

Show sql statements from mysql binlog (GTID)

By adminPosted on September 16, 2022

Question : I have mysql binlogs for replication through GTID. I’m trying to show executed update/insert statements like this: mysqlbinlog […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Convert seconds into HH:MM:SS format in MySQL
  • Guaranteeing a FK relationship through multiple tables
  • Is it Possible to Recover Data from a BLACKHOLE table? [closed]
  • MySQL: sysbench test – InnoDB vs Memory tables
  • Why are virtual log files not always allocated in order?
  • Need help to understand how information_schema.TABLES get updated
  • unique constraint on a set
  • PostgreSQL, integer arrays, index for equality
  • What is the most performant way to group by and join high cardinality columns in column based table?
  • LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?
  • Is a process created in Oracle for every SQL statement?
  • How to select a row based on the maximum value of a column, when ties are expected
  • I am unable to join tables in correct manner
  • How often to backup database and what are the favoroble practices to do so [closed]
  • In Postgresql, after pg_dump the access privileges on the database itself are not restored
  • InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
  • Which version of SQL Server 2016 supports R
  • Design DB for users with different information fields?
  • WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)
  • Speeding up group by and max query

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding