… 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… may argue you still will have the problems with such design in CPU bound case – yes you will but it will…
Post: Upcoming Webinar on Index Design
October 1, 2012 By 2 Comments
The proper tools and techniques for designing indexes in MySQL is a broad subject, which causes grief …. I’ll present a webinar Tools and Techniques for Index Design on October 3, 2012 at 10:00am Pacific time to… the best practices and procedures for you to build index design into your development and operations work. Please register for this…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… is public I can write down my thought about its design, which I previously should have kept private as I partially… 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…
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… They may not agree to give up features they have designed but still would like to note it will require 30…
Post: Webinar: Avoiding common traps when designing a MySQL application
January 7, 2013 By 4 Comments
… webinar about the main traps that are awaiting you when designing and building a stable and high-performance MySQL application. I…
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…
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… tuning parameters that are absolutely necessary, PBXT is not specifically designed to be self-tuning, because I believe that is a…
Comment: Why you don't want to shard.
August 6, 2009 By 34 Comments
… it bad. The real danger of implementing sharding is bad design. Bad design is ‘bad’ complexity. In relation to your article, there… depends on the application and framework design, not the fact that it’s sharded. If you design your sharding infrastructure with simplicity… fully understanding your entire architecture. – Complexity isnt evil, but bad design is. If you do have to shard, 90% of your…
Page: Consulting for MySQL
July 31, 2006 By
…, Schema, Queries, Application Architecture, Caching etc. MySQL High Availability design and implementation Design of High Availability architecture which matches your application needs… configuration and troubleshooting platform related issues ? We can help you designing optimal hardware configuration and deployment setup which will match your…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 18 Comments
… storing and querying trees in an SQL database, including the design I call Closure Table. In Closure Table, we store every… 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…
