I did some drawing exercise and put XtraDB / InnoDB internals in Visio diagram: The XtraDB differences and main parameters are marked out. PDF version is there http://www.percona.com/docs/wiki/percona-xtradb:internals:start.
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…_pages_free). This is the exact formula that InnoDB uses internally to estimate current innodb_dirty_pages_pct. checkpoint age – This… average result is 37235.06 NOTPM. This allows me to draw a conclusion which partially concurs with the conclusion in article…
Comment: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 5, 2008 By 15 Comments
…-page), there should be no changes on disk or in internal processing. We would not expect a significance difference in performance… more data and some further analysis, it is difficult to draw any reliable conclusions. We appreciate your interest in InnoDB and…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… are however need to be exact to be able to draw pager properly. The hard part in social network search is… by distance and we’ll need to look at some internal relationships support which are required to avoid massive data duplication…
