June 20, 2013

Post: System size and Performance Optimization

February 27, 2007 By 2 Comments

Performance optimization is never ending story, you can virtually always find something else to optimize but while on generic system, not tuned by expert you often can get significant performance increase in the… things as optimal as possible. If you’re using 50 5000$ database servers to run the system even 10% performance increase mean…

Filed Under: Insight for Developers Tagged With:

Post: Announce: Front End Performance Optimization

October 10, 2008 By 8 Comments

… from the client prospective where our new service – front end performance optimization comes to play. We look to reduce number of requests… page to start render as soon as possible. Front End performance optimization is often needed to change your site from good to…. By adding front end optimization services we are able to help to deliver great performing web sites whatever performance limiting factors are. P…

Filed Under: Events and Announcements Tagged With:

Post: Innodb Performance Optimization Basics

November 1, 2007 By 75 Comments

… optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal… default as transaction-isolation=READ-COMMITTED. This option has some performance benefits, especially in locking in 5.0 and even more…

Filed Under: Insight for DBAs Tagged With:

Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization

September 17, 2007 By 14 Comments

… and workaround this limitation, though it of course comes with performance penalty. This approach is however still faster than running 2… well implemented inside MySQL. Why am I looking on reporting performance optimization ? It is for ClickAider project which is growing rapidly and… lot of other black magic to keep things as optimal as possible though performance is still far from our goal of real…

Filed Under: Benchmarks, Insight for Developers Tagged With:

Post: Performance Optimization and Six Sigma

June 7, 2010 By 6 Comments

… MySQL (and general Web performance management) ? Not So good. In most cases organizations focus on performance rather than performance stability even though it….7%. One reason we use rather weak confidence intervals in performance optimization is we need a lot of transactions to get stable…

Filed Under: Benchmarks, Insight for Developers, MySQL

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

… matched records, checking attributes is not going to slow down performance of queries significantly. But – and this is the misuse that… requires that all attributes fit in memory or the server performance will be simply unbearable. However, that still does not mean… I thought I would emphasize – while it is a neat performance optimization for highly selective attributes, this is certainly not something you…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Goal-Driven Performance Optimization white-paper available

May 4, 2010 By Leave a Comment

… we were distributing, titled “A brief introduction to Goal-Driven Performance Optimization.” This is a super-compressed technical introduction to one of…

Filed Under: Events and Announcements, MySQL Tagged With:

Post: Guidance for MySQL Optimizer Developers

September 20, 2009 By 4 Comments

… spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably last… CPU and IO cost. Focus on Execution Methods Performance problems can be due to optimizer picking the wrong plan, such as doing… one which actually gives best performance). I also recognize there are always going to be cases when Optimizer will not pick the…

Filed Under: Insight for Developers, MySQL Tagged With:

Post: ORDER BY ... LIMIT Performance Optimization

September 1, 2006 By 100 Comments

… the cause of MySQL Performance problems. Here is what you need to know about ORDER BY … LIMIT optimization to avoid these problems… on date_created separately would still work. The good from performance standpoint (even though a bit ugly) will be UNION workaround… wrote about. So what if you have application which can perform search on many different columns, with worse then perfect selectivity…

Filed Under: Insight for Developers Tagged With: ,

Post: Full table scan vs full index scan performance

November 23, 2012 By 15 Comments

… with EXPLAIN as Extra: Using index) is a very interesting performance optimization, a full index scan (type: index) is according to the… obvious that a full table scan is not good for performance, how much can we expect if we can switch to… scan and no filesort. But predicting how a query will perform by only looking at the execution plan is not enough…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,
« Older Posts
Newer Posts »