…of outages can happen? Someone runs UPDATE or DELETE and forgets the where clause or filters…With mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “…-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL I…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
… query log from standard input (stdin) instead of log file. For this release binary …just the SELECT but the UPDATE,DELETE and INSERT ones as well….file=example.dump \ –tcpdump-mode=accurate –db-plugin=libmysqlclient –mysql-host=10.8.2.10 \ –mysql-username=root –mysql-password=passW0rd –mysql…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…outline of improvements available in MySQL 5.6 which I …Separate Flush Thread – Group Commit for Binary Log – Fight Cache Coherence and False …File I/O Instrumentation – Improved EXPLAIN – - Explain for UPDATE/DELETE queries – - JSON output with more information – Optimizer Tracing – Deadlock Logging…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…binary logging will be performed by this statement in row-based logs, but the DELETE will be written to a statement based binary log…binary log, only positions. mysqlbinlog mysql_sandbox25162-relay-bin.000005 –base64-output=decode-rows -v > decoded.log Examine the decoded binary log…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB:…I get the message in the log file about checksum failing CHECK TABLE says …or delete any data (though you can create or drop Innodb tables): mysql> optimize table test; …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…attempted. btr0cur.h: /* In the pessimistic delete, if the page data size drops…in an ascending order of the file address, then InnoDB schedules the …Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex… again. PZ: You can disable binary logging to get Group Commit back. …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… Master Server (default) # binary logging is required for replication log-bin=db1-bin log-bin-….info file, unless you shutdown # the slave server, delete master….mysql/data/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/data/ #innodb_log…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… innodb_locks_unsafe_for_binlog option with caution. Note disabling binary logs is not enough to trigger relaxed locks. You have to…_for_binlog=1 as well. This is done so enabling binary log does not cause unexpected changes in locking behavior and performance… aproach make sure to delete file after it is loaded back (it has to be done outside of MySQL Server) as otherwise the…
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
… the xtrabackup binary of xtrabackup1.2 to do the incremental backup, have a error.how to resovle it? OS: centos , MYSQL :MYSQL 5… smaller log files, shut down the InnoDB: database and make sure there were no errors in shutdown. InnoDB: Then delete the existing log files. Edit the .cnf file InnoDB: and start the database again. xtrabackup…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 29 Comments
… things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows …not the actual imported data. If the INFILE data file is missing from the slave boxes, then the … on master (BEWARE: you should make sure to delete the INFILE from the slave’s filesystem). e.g…
