… do these days. There were quite a bit of mistakes in design for this one which I though worth to note, adding…
Post: Beyond great cache hit ratio
May 19, 2010 By 2 Comments
… complicated to add it to existing code which was not design with it in mind. Multi-Get effectively allows you to… indeed there is a lot of art and science in designing optimal cache solution. The good thing is most web sites… good enough performance, it is most important to avoid biggest design mistakes.
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… this post I will just look at couple of query design mistakes which result in low hanging fruit troubleshooting MySQL Replication Lag… are much more rows examined than modified. The next common mistake is using INSERT … SELECT – which is in similar to what…
Comment: How to find wrong indexing with glance view
August 22, 2008 By 27 Comments
tgabi, Multiple column indexes will be a lot faster than multiple single column indexes in case there is good cardinality on both columns and full index can be used. Relaying on index-merge is actually very typical design mistake.
Comment: Content delivery system design mistakes
February 11, 2007 By 9 Comments
[...] MySQL Performance Blog » Content delivery system design mistakes (tags: mysql performance) [...]
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance. But such mistakes are relatively few and/or non-…hardware The server configuration The workload The queries The schema design (table design, data types, indexing, etc) The data itself All of…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… ecommerce package which makes me want to voice a recurring mistake I see in how many web applications are architected. What is that mistake? The ecommerce package I was working with depended on caching… on instrumentation-for-php. In terms of future-proofing design, many applications are better off keeping it simple and (at…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 42 Comments
… don’t think we should necessarily look to them when designing our own applications. @Robert – thanks for your comments 
Josh Berkus… they are so specific. I think one of the common mistakes people make is they don’t interpret the mixed-requirements…’ to convert everything over to E-Blob. That’s a mistake. My message here is that E-Blob is okay, but…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… modest. DVD Store was special > type of application which was designed to have very simple logic > besides database – in most cases… with traditional database background. > Things are different with MySQL. Good design will help dictate how many tables are required in order… original article, however I think this > is the most common mistake and it is very important to fix it. Most > applications…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… (like excessive row level locks) may be caused by application design. Another thing to consider – even if you have unlimited money… things yourself. Learning to understand the basics allow you to design the application more efficient way and you probably do not… you could and what you’re not doing some silly mistakes with application architecture or table structure which may cost you…
