… track record with MySQL Performance Blog – there were times when site was slow (especially when backup was running) but I do… I should try to boot it in “Last known good configuration” for which I point him it is not Windows. He… to match my timing so I went ahead and returned web site back to old server which happily was still available. Now…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… for medium size web sites which have millions of page views per day. Typically single Apache server in this configuration will have rather high MaxClients settings (in hundreds) and would argue web site performance suffers if the…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… to help people to build and operate quality systems, typically web sites, which means we help customers with performance, scalability, high availability… look at MySQL driven web site its properties will likely depend on a lot of factors – good web side configuration, which is about caching… people make a mistake by thinking their site are already great by looking at their web site from location which is close to…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… delivery, serving file downloads and images – something a lot of web sites need to do these days. There were quite a bit… but it works if configured well. In this case however the problem was zero TTL set in DNS configuration. This obviously adds… already mentioned serving different content requires different skills from web servers or different configuration, so it is good idea to use dedicated…
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
I did not usually go to “Elite” servers on Dell web site but looking at customers system today I went to check… default configuration to 128GB of memory will cost you just $9600 (list price). I’ve been able to configure on a web the system with 8*2.5″ hard drives RAID and 2 CPUs (just as we usually configure PowerEdge…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… milliseconds to stall for few seconds, especially in certain OS configurations, and on low profile servers (ie having only one disk… do not suffer from table locks reporting queries can affect web site performance dramatically. Sometimes instead of using slave you may use… about it, it may be still too bad and your web site users may be suffering when you can’t notice it…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… are shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for… also seems to have another issue – as said on their web site when you post an item it takes up to 3… I think both of this sites have the same mistake (or shortcut) in MySQL Full Text Search configuration – relaying on minimum keyword…
Post: Using index for ORDER BY vs restricting number of rows.
February 16, 2007 By 7 Comments
… BY or using index for restriction. Consider we’re running web site which sell goods, goods may be from different categories, different… seller, price, date added etc. Such configuration often causes serious challenge choosing proper index configuration as it is hard to add all…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
… you would ask me what hardware you need for ecommerce web site with 100.000 visitors per day I still would not…. These would of course apply to particular system in particular configuration but it will be rather accurate. Many people however would…
Post: Speedup your LAMP stack with LigHTTPD
May 21, 2006 By 14 Comments
… buffering (ListenBacklog 1024) but such approach is often bad for site performance. Even if you can balance it to work right… Most of light http servers support such configuration. There are several benefits in this configuration. One obvious one is Caching – it however… servers might be configured differently. You also may have different routing policies set for these servers – you want Web pages do be…
