… DO NOT CARE about binary log position of backup XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well… at –backup when added –stats New option –stats to gather index stats Fixed some bugs for a 32bit platform Fixed bugs… Percona-XtraBackup: “can’t backup tables with $ in name” The binary packages for RHEL4,5, Debian, FreeBSD, MacOS as well as…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
…even in extreme cases such as melt down file system or broken down RAID. We can undelete… also can get some data recovered from covering indexes and other areas, continually improving our tool set…. bit. We had to recover data using query log, corrupted binary log and dig into MyISAM tables. You would…
Post: Small things are better
October 8, 2006 By 15 Comments
… corruption is happens to be in undo tablespace or log files. So do not forget to have your recovery … especially if you do point in time recovery using binary log to get to actual database state. The good … will be much faster this way as whole indexes will well fit in memory for such small tables…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… table to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set… if tables on master and replica are different. binary log should be a good place to look for these… be executed on db2 so better use mysql file socket, or real IP of the node, but…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log…any one of these factors (schema, queries, indexing) in isolation, because they are tightly …binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… hex (16384 bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page checksum …6353 InnoDB: Page may be an index page where index id is 0 25556 InnoDB: (index “PRIMARY” of table “test”.”… even though I get the message in the log file about checksum failing CHECK TABLE says table is OK…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
…_PAGE_INDEX/ Binary file pages-1345220873/FIL_PAGE_INDEX/0-18/9733-00009792.page matches Earlier Aurimas explained how to deal with tables with binary… the changes a transaction does are written to the redo log right before a successful response to COMMIT(or in a… can scan the redo log: # ./s_tables /var/lib/mysql/ib_logfile1 sakila/actor sakila/actor 15 # ./s_indexes /var/lib/mysql…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file…, you can take one of our binary builds with 5.1.36. …log InnoDB: import: extended import of testexport/order_line is started. InnoDB: import: 2 indexes…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… to find the different indexes and types. mysql (information_schema) > select i.INDEX_ID, i.NAME FROM INNODB_SYS_INDEXES as i INNER… all the information related with tables and indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor… the original tablespace and also from an ibd file if you have a binary backup. Just use constraint_parser without the -D…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… restoring from the LRU dump file is synchronous, i.e….adding an index using Fast Index Creation, statistics for that index provided…Log did not log the error number correctly. #830199 (Oleg Tsarev). Variable log…see the following links: Downloads: Binary distributions, Percona Software Repositories …
