…applies the redo-logs to the dirty tablespace and voila, you have a consistent binary backup at …procedure I used: Locate an existing snapshot that contains the schema you are interested in (/tmp/…SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<'EOF' > import-ddl.sql …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…Binary Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log …> c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql> insert into … two columns, but the changelog contains five. All change logs contain three additional metadata columns: …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… using Innodb you also might with to use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5… can also have relay logs corruption and master.info being corrupted. Not to mention MyISAM tables can contain partially completed statements as…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
We made new binaries for MySQL 5.0.67 build 10 which include next fixes: We addressed concerns about potential logging and statistics… Cole | N/A | | | innodb_io_patches.patch | Cluster of past InnoDB IO patches | 1.0 | Percona | GPL | This patch contains fixed (control_flush…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
… mysql-bin.005000 position 10000000 which failed with “Could not find first log file name in binary log …binary log file mentioned did not ever exist on this master. What is going on ? The thing is Innodb… copy and the log file numbers restarted back from 1 but tablespace still contained the ancient …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…your data (total size of Innodb TableSpaces) because it does not only contain data pages – it also contain adaptive hash indexes, insert …cache for – MyISAM tables (mysql database, temporary etc) will need it, .frm file, binary logs, or relay logs, Innodb Transactional Logs also like to be cached…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…initial tests, I used MySQL 5.5.8 (the tar.gz binary from dev.mysql.com), and for …page – This graph will contain the percentage of dirty pages in the InnoDB buffer pool. This value …MySQL 5.5.8 by tuning innodb_max_dirty_pages_pct and innodb_io_capacity; but the limiting factor is still innodb_log…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a …It is used to prevent wide innodb primary keys on the MV. mysql> select mview$pk as … computed them. And then confirm they contain the same results mysql> select sum(total_lines) from …
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only way… compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events, which could be the… which makes it easy drop in replacement. I got LZOP binary which was built against LZO 1.0, more resent version…
Post: Announcing Percona XtraDB Cluster 5.5.27-23.6
September 7, 2012 By Leave a Comment
… XtraDB Cluster on September 7th, 2012. Binaries are available from downloads area or… has implemented ability to have a MySQL Utility user who has system access…INNODB_UNDO_LOGS has been added to allow access to undo segment information. Each row represents an individual undo segment and contains…
