…InnoDB DEFAULT CHARSET=latin1 Notice that in the case of child_A there is an implicit FK relationship to… on how SchemaSpy identifies the relationship, and whether you need to …tables with the string NULL instead of the actual SQL NULL value. This is basically a quick sanity check of your schema for…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… that performs non-blocking backups for InnoDB and XtraDB databases. This release …the interval configurable allows to reduce the time between checks which can … Example of how this information can be used to create/restore … Fixed by removing files corresponding to tables that are missing in the…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…how to setup and run this benchmark, can be found here. We decided to run this benchmark for…to check…how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…the interval configurable allows to reduce the time between checks which can … Example of how this information can be used to create/restore … Fixed by removing files corresponding to tables that are missing in the…innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726. For…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…to work with PXC and figure out which tools work with it and how. There’s still one noticeable omission: pt-table… for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb…version check” into most tools. It’s like a lot of software that automatically checks for …
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
… tables back with page_parser and constraints_parser tools. You can check the docs how to do it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start . The biggest challenge here is to find index_id for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… want to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So we looked at how to get your data back from simple Innodb Table…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…to include others as well. Here’s how you can use our new monitoring plugins to check for some of the conditions that caused downtime for…check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: InnoDB free: 6144 kB *************************** 2. row *************************** Name: cbool Engine: InnoDB…for MyISAM and Innodb tables, however it is not as convenient to…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…how it could be possible to recover, on some specific cases, a single table from a full backup in order to…re going to use to achieve this objetive is Percona Data Recovery Tool for InnoDB….to remove the innodb_table_monitor. C) Check the size on disk of every indes This is very dependent of the table…
