…post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size … TableSpaces) because it does not only contain data pages – it also contain adaptive hash indexes, insert… of MyISAM, Archive, PBXT, Falcon or other storage engines then you will get into complex …
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…It is also worth to note Innodb (which is storage engine which usually considered best for parallel insert/… because UUID will have recent data scattered all across. Lookups Later in comments Brian mentions the point of … than SHA1 as Kevin proposes in the same post – hashes if it is SHA1, MD5 or…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…XtraDB, which is our new high-performance transactional storage engine Maatkit, which is a toolkit that …not released yet. The general public. People comment on our blog posts, or send us email, and so… the MySQL server, XtraDB, Maatkit, our InnoDB data recovery tools, MMM, innotop, or even projects …
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…) Xeon(R) CPU E5-2660 0 @ 2.20GHz Memory: 192GB Storage: Hardware RAID10 over 8 disks, card: Perc H710, disks: Seagate…, 50, 75GB to have different memory/data ration. And we test it on two storages: HDD RAID10 and Intel SSD 910 Results… innodb_flush_log_at_trx_commit=2, which in comments to previous post was called cheating. So I ran another round with…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… above, probably you have more than 1TB of data. You say you cannot afford the restoration time … the types of queries you run against the storage engine. 4. InnoDB is far from being perfect. 5… with regard to your post. As a final suggestion, please read Peter’s comments again, they are very helpful…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…more about disks. You might have read my previous post and Matt’s Reply and it looks like …the article lets comment on IO vs Disk question. If you look at Disk Based databases all data accesses are…first look how single query is executed for Innodb storage engine to be more specific. Lets look at …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…out of this. I had added my comments to some of the questions. HT … table. Among other things compression for data pages and uncompressed index pages can be…in size. I should also mention a post on this topic once. Q12: If …removed most of the 768 byte local storage in the record. In that source code…
Post: Bug#12704861
November 20, 2011 By 1 Comment
…full documentation from the release notes: “InnoDB Storage Engine: Data from BLOB columns could be lost if the…MTR_MEMO_FREE_CLUST_LEAF operations have been posted. row_ins_index_entry_low(): When columns … to avoid leaking pages. row_build(): Correct a comment, and add a debug assertion that a record…
Post: Why delayed flushing can result in less work
December 9, 2009 By 5 Comments
… reasons why systems delay flushing changes to durable storage: 1. So they can do the work when …the second property can be true. A commenter on Deva’s recent post on InnoDB adaptive flushing asked, That’… crazy, write as much as you want. If the data fits in the buffer pool, no reads are happening…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 47 Comments
…to extract from what Mark Callaghan posted and say the edge case…with Barracuda offering fully off-page storage. @Alan – The ORM should be … applications. @Robert – thanks for your comments 
Josh Berkus cited upgrades as … out, examines, and sends some data back. On Debugging – Particularly w/…
