… load. Some factors that affect speed of restore include innodb_log_file_size, innodb_buffer_pool_size, innodb insert buffer (default to 50% of… things up nearly as much. I recommend testing restores using different number of restore threads and measure time taken. Compare this to… primary purpose of logical restores are when retrieving a subset of data such as a single table or a single schema which is only…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… InnoDB tables — don’t use GUIDs. Which brings me to my next point: Use InnoDB Assuming…single server (or if you’re using replication, the capacity of a single slave). Sharding can also help you avoid massive tables…to avoid enormous tables that are hard to maintain, back up, and restore. And the…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 10 Comments
…. I want to restore this database (called tools). But I am not able to do a SINGLE DATABASE restore using the copy-back… I am able to view/access ONLY MYISAM table – but none of the InnoDB tables. Is there something which I am missing? Do… any directive in the my.cnf file to access the InnoDB table? Please help. Thanks in advance. Abhilasj
Comment: My "hot" list for next InnoDB features
October 11, 2009 By 18 Comments
It’s a table cold backup and restory without shut down of InnoDB Restoring a single .ibd file http://www.innodb.com/doc/hot_backup/manual.html#partial.restoring.single
Post: Wishes for mysqldump
May 22, 2007 By 19 Comments
…in parallel single thread …tables which have different priority for your application. Safe Dump Dumping corrupted Innodb tables you will have some of the them crashing Innodb…table was not dumped successfully, wait for MySQL to complete restart and continue going with other tables. Parallel restore…
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
… each production server restoring the dump on the node that will be the dedicated slave convert the table in InnoDB configure and start… times… that could take some time ! And then, if the single production servers where more than 3 ? So I decided to… to be slave of all production servers, changed the table engine to InnoDB on it and chose one node of the PXC…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… curious how you’re dealing with repairing of these MyISAM tables or are you switching to the slave because you do… would. You still did not answer WHY you need to restore single table. What condition causes this ? Typically there are following conditions 1… with Innodb reviewing your application. Just recognize it is not typical. Working for a long time for a single company with single class…
Post: Small things are better
October 8, 2006 By 15 Comments
… have backups for. Backups however take time to restore, especially if you do point in time recovery… column to 500GB Innodb table. It will probably take long hours or even days for ALTER TABLE to complete…at 256 groups of tables. Current data size is small enough so even single table would not be big…
Comment: A recovery trivia or how to recover from a lost ibdata1 file
September 1, 2012 By 8 Comments
How can I restore a partitioned mysql InnoDB table from just the .ibd files of the form TableName#P#…://www.chriscalender.com/?p=28 works for non-partitioned tables with a single .ibd file, but the “discard” and “import” steps result…”, which I tried as “alter table TableName partition by range … (partition pname1 values less than (…) ENGINE=InnoDB)”shockingly replaces the TableName.ibd…
Comment: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… there was a way to automatically verify the backup using InnoDB crash recovery. Or perhaps I am misunderstanding the point. Karan… and Amazon S3 for storage. It makes it easy to restore single tables or even a whole database. I will be releasing it…
