… target for web applications. So designing your application think what kind of application are you designing ? Can you make it CPU bound/In memory ? If… be required to get your application back to speed. The cases when going from CPU bound to IO bound hits the most is there… flag for your main select query. If you’re having CPU bound application it is as much as you might need to go…
Post: XtraDB in CPU-bound benchmark
December 18, 2008 By Leave a Comment
… run for CPU Bound,or it would be more correctly to say in-cache benchmark, because there is a lot of CPU remains… buffers are flushed. This is serious issue in real life application even though it does not significantly affects average throughput. Honestly… utilize CPU more fully XtraDB will show more gains, though not 1.5x as for IO bound workload. One may ask why CPU…
Post: Scaling IO Bound Workloads Webinar
June 19, 2009 By 2 Comments
… IO Bound Workloads in MySQL. My part of the presentation will be speaking about why switching from CPU bound workload to IO bound is such an important event, how to prepare to it as well as how to keep your application…
Post: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
… this is hell a lot of difference ! Depending on your application performance with single thread may be important or non important… active replication, if you’re running time sensitive long running CPU bound queries or if queries contribute significant time to generating web… which would be well above performance guidelines for many web applications. I’m hearing Sun is working on new CPUs which…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… application logical serialization problems. So what if we have very IO bound application without serialization issues (say reporting slave) which is very IO bound showing 100% IO subsystem utilization on 5% of CPU usage…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 4 Comments
… it does not really tell you if it is CPU bound load or IO bound load. For example if you have LoadAvg of… it is CPU bound – because the system can execute much more CPU bound tasks in parallel or High if it is Disk Bound LoadAvg. Low… – system may be quite idle and performance still poor because application is not parallel enough. Similar situations can happen if there…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… profile not CPU-bound load (for CPU-bound there is OProfile, see for example http://mysqlinsights.blogspot.com/2009/08/oprofile-for-io-bound-apps… is you can use it to profile your and any application that has -debuginfo packages ( all -debuginfo for standard RedHat RPMS…, there seems another war story going on. To profile userspace application with SystemTap your kernel should be patches with uprobes patch…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
… code design, others, such as row level locks would require application changes to allow more concurrent process. The scalability numbers depend… and workload. Data size impact There are different type of applications out of there. Some (minority?) vary the load independently or… in memory, hence having CPU bound workload. As your data growths you may frequently find load becoming IO bound and hence things becoming…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… – adding index you rarely would add bugs to your application while redesigning application schema or implementing caching are much more bugs prone…. If single user CPU bound query takes 30 seconds you unlikely will be able to solve the problem by CPU upgrade. For single… it even can take less time than moving the application. On reasonably tuned applications when further tunings are expensive you may well…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
… “test” application and looked at boosting performance of the application by buffer MySQL with memcached. Our test application is simple and… example an application is CPU bound, so you add more processing power, but then you hit disks harder and now your disk bound. A… most people use their database for. Each application is different and understanding the application‘s requirements is key to picking an appropriate…
