…Versioning in Innodb – when you write the new data the new version for the block is stored in undo space. …of undo space should be enough. Though you may wish to give you some breathing space. Of course …when you might want to do maintainence or batch job, which well may require a lot of undo space…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…with so much different “depth”. For some this is 15 minutes job for others it is many month projects…lot of time you may wish to create second QA/dev environment just for this project. Query …this version (or selecting to use version only for new shard and measuring its capacity) Setting up the…
Comment: Tom Basil (formerly MySQL's Director of Support) Joins Percona
December 11, 2008 By 13 Comments
Tom, I wish the best for you and your new job. My promise is still being kept and shall pay you … trip will come! Please send me an email with your new contact details … To all mysqlers: I miss having drinks and…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…happens, but not often, that someone just writes new functionality for free in spare time.) However, if the work…more people find out about the possibility for getting their wishes. This model lets us work on features…sense in doing a halfway job of it. So that removes the motivation for us or our …
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… chart with results for InnoDB vs InnoDB-plugin during runs (values are in new order transactions per minute…, and there big room for improvements. As for InnoDB-plugin, I’d wish InnoDB team makes some … throughput of FusionIO. XtraDB is doing better job with internal contention, but much more can be…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…many tables are required in order to get the job done. To be good at designing an application, …means longer restore times. Deciding to create a new table for a part of the data set is not a…often do much better with denormalized data. You may wish > to use denormalized data as cached lookup table …
