… advantage in practice? I will show the performance of two real customer systems running web applications. Let’s begin with a system running in a popular hosting provider’s datacenter. This application is a… the view of the same data to look at it disk-by-disk, aggregated over the entire 30 seconds that I captured…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…disk would be the problem. However it is not always the case. There are whole classes of systems where Disk performance…to get a lot of data in. Many Web 2.0 sites in particular design for …in memory fit. For large number of applications optimizing IO performance will be number one problem do not…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… need to go to the disk, lets say even only in 10% of the cases and so perform 1000 possibly random reads… way more than you should target for web applications. So designing your application think what kind of application are you designing ? Can you make… be responsible for majority of performance problems. Let me illustrate it on simple case. Assuming you have Web application which has some form…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… is in cache will require an extra disk seek. Also remember each BLOB which does …practice table size reduced over 5 times and performance gains were even better because much fewer …. However it works great for many standard Web application needs – storing blog posts, product descriptions, forum posts…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… makes me to write again 
Most Web applications we’re working with have single tier web architecture, meaning there is just single set… figure it can be something like 2*(Num_CPUs+Num_disks), sometimes less sometimes more. With optimal concurrency you get optimal… static. So with Web applications your need limited number of workers – (I’d guess 20-30) to get best performance, this is of…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…applications. For example for application containing a lot of clode but having only couple of queries to MySQL parsing may be performance… Cache for single node applications If you have just one web server or your data …which supports caching user data both on disk and in shared memory. Appendinx: If …
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 4 Comments
… or High if it is Disk Bound LoadAvg. Low Load Average does not mean there are no performance problems, for example if… are a lot of CPUs and Disks – system may be quite idle and performance still poor because application is not parallel enough. Similar… as good as down. First for many applications request inflow is not constant – ie web site gets poor response time and users…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… they were in pain) and 37Signals When doing Performance Audit we tend to look at the …not only store the copy of data on the disk, wasting resources but their caches are also … from the Slaves The story heard is typically – Web applications often have significantly prevailing reads so to scale…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… corresponds to typical structure you would see in OLTP or Web applications – medium size rows, auto increment primary key and couple of… to see performance and scalability in this simple cases. We also use CPU bound workload in this case (no disk IO) to… data on disk) 2. Run each query for 1, 4, 16, 64, 128, 256 concurrent threads. 3. For each thread perform a…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… corresponds to typical structure you would see in OLTP or Web applications – medium size rows, auto increment primary key and couple of… to see performance and scalability in this simple cases. We also use CPU bound workload in this case (no disk IO) to… on disk) 2. Run each query for 1, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform a…
