… Enumeration design for your purposes. I’ve seen only one book that investigates methods of using SQL to work with DAGs: “SQL Design Patterns” by Vadim Tropashko. http://www.amazon.com/SQL-Design-Patterns-Programming-In-Focus/dp/0977671542…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to be made read only is very short, just few seconds, yet the impact of… this problem fixed. There is no reason (other than code design) for read lock to wait for other read lock in…
Post: Only Design What You Can Implement
March 26, 2007 By 1 Comment
… of problems are coming from very simple fact – product is designed containing features which developers do not know how to implement… features working exactly as required. So what is my point ? Only plan for features which you know how to implement to… They may not agree to give up features they have designed but still would like to note it will require 30…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… base of my MySQL use with existing applications – if you design new applications which are done specially for Falcon you might… 8-16M as you need with page cache. There are design techniques though to improve page cache efficiency in this respect… will see is having consistent snapshots being consistent for database only, so if you have started transaction accessed table in database…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… should target for web applications. So designing your application think what kind of application are you designing ? Can you make it CPU… solutions which are easier to implement. But beware if you design your application as CPU bound and when it scales so… them all using only few physical IOs. You may argue you still will have the problems with such design in CPU bound…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… these days. There were quite a bit of mistakes in design for this one which I though worth to note, adding… may be something else. It looks very attractive to keep only one thumbnail and simply set browser image sizes if you… want to be quickly visible to infinity for objects which only change with their urls. Server side caching The benefit of…
Comment: Only Design What You Can Implement
April 2, 2007 By 1 Comment
Implementierbarkeit ist nicht optional… Netter Artikel von Peter Zaitsev zum Thema: Only Design What You Can Implement…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… performance is similar to InnoDB but, depending on your database designed and the application, it can be faster. PBXT is a… have very few configuration parameters. Â Was this an intentional design decision, and do you see it creating opportunities for you… is not by design. While I try to only add tuning parameters that are absolutely necessary, PBXT is not specifically designed to be…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… they are designed to be simple. A classic example is a simple online game. An online game may only require that… part they are designed to be simple. A classic example is a simple online game. An online game may only require that… lean and performs well. The issue is even this simple design can start to have issues as the data size increases…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 7 Comments
…, including the design I call Closure Table. In Closure Table, we store every path in a tree, not only direct parent-child… there isn’t much written about using the Closure Table design, I periodically get questions about how to solve certain problems… It can be easier with the Adjacency List design, but in that design you don’t have a convenient way to query…
