… sweep. Here is how I like to use it for web site performance analyzes. As you can see in this table we have… “so so” as we set 300ms or less as performance goal for the web site. 4% of these requests get ranking “poor” being… but may be less used functions performance problems. Another thing you may notice I look for performance stats not for all pages…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large … do not suffer from table locks reporting queries can affect web site performance dramatically. Sometimes instead of using slave you may use database… about it, it may be still too bad and your web site users may be suffering when you can’t notice it…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… to build and operate quality systems, typically web sites, which means we help customers with performance, scalability, high availability as the whole, not… perform any slower in this case. By adding front end optimization services we are able to help to deliver great performing web sites whatever performance…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… else. This architecture is frequently used even for medium size web sites which have millions of page views per day. Typically single… have rather high MaxClients settings (in hundreds) and would argue web site performance suffers if the value is decreased, only few however understand…) to get decent performance ? Network IO – This is actually the only valid one. If you’re querying Amazon Web Service for example…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… interactive applications with large data sets being sorted. On many web sites you will fine top tags, recently registered users etc – which… on date_created separately would still work. The good from performance standpoint (even though a bit ugly) will be UNION workaround… looking at 200+ page in my projects. Also for many web sites failing to take care of this provides very easy task…
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
… we had pretty good track record with MySQL Performance Blog – there were times when site was slow (especially when backup was running… lucky and in about a week after we moved MySQL Performance Blog to the new server, it stopped responding. I went… to match my timing so I went ahead and returned web site back to old server which happily was still available. Now…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… for many performance optimization tasks not only because of labor associated expenses but also because of the suffering – slow web site means your… mention looking at performance statistics for the day overall is often not enough. Application performs as good as it performs during its worst…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… of CPUs and Disks – system may be quite idle and performance still poor because application is not parallel enough. Similar situations… the box it will perform well as soon as you need to do a lot of queuing performance starts to suffer. Let…. First for many applications request inflow is not constant – ie web site gets poor response time and users do not spend so…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 14 Comments
… top X values. If you analyze Web Site logs you would look at most popular web pages or search engine keywords which bring… 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…
Post: Understanding Performance Optimization Terminology
March 2, 2009 By Leave a Comment
… and people not understanding the difference between them. Performance – The performance comes down to performing up to users expectations (or expectations of your… I would define Scalability as ability to increase or sustain performance as response to the environment changes. Efficiency This is my… how efficient and inefficient systems you can find among top web sites. It is not an exception to see the difference in…
