Question : My installed versions of MariaDB and Percona Toolkit on MacBook: brew info percona-toolkit percona-toolkit: stable 3.0.10 (bottled), HEAD […]
Tag: binlog
MySQL : Extract SQL statements from binlog
Question : I am trying the following command to extract SQL statements from binlog for using it in another database […]
MySQL : 30GB of binlogs in 6 Hours
Question : I have a mysql master/master setup with tungsten replicator. My server is reaching out of space, occupied around […]
MySQL Crash After Starting Binary Logs
Question : Recently I have added binary logs to mysql to start replication but after that setting, mysql process failed […]
What is the safest way to switch the binlog format at runtime?
Question : Because of the following warning in mysqld.log: [Warning] Unsafe statement written to the binary log using statement format […]
what happens If I remove mysql-bin.index file?
Question : Because of the file storage full, we are removing mysql bin log files. Accidentally, we removed mysql-bin.index file. […]
Hi disk I/O and crash when turning on sync_binlog in MySQL
Question : I have a MySQL master server (MariaDB 10.0.17) that have a very odd behavior. It has one slave […]
Unable to show binary logs how to remove logs from mysql?
Question : Server version: 5.1.50-log MySQL Community Server (GPL) Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the […]
Mysql binlogs exists, show binary logs is empty
Question : I am working on a replication setup and have turned on bin-logs. I have moved my mysql datadir […]
MySQL: Why statement-based binlog format cannot work with Innodb READ UNCOMMITTED or READ COMMITTED Isolation levels?
Question : In MySQL documentation it’s written: If you are using InnoDB tables and the transaction isolation level is READ […]