… 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… a megabyte per second of writes, but the performance (latency) is both large and variable even though the devices are idle most…
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
… data is a big problem for growing SaaS businesses and large web applications. In this webinar, we’ll teach you how to set… high transaction performance like InnoDB buffer pool dump/restore and HandlerSocket, our favorite tricks for backup, restore, and provisioning of large data…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… web applications have to handle much higher load and much larger data sets, they are also much more complicated and performance of MySQL is… very large scale systems. This is the area where I would expect next big innovation to happen, when it comes to Web applications. Web applications…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…performance optimization is going to be more important for your application depends on the application performance a lot. The better your application…wait times – mysql, memcache, sphinx, web services etc. For web applications doing processing…be enough but for large scale application I’d recommend to…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… same as with MySQL Replication – the reason it is fast and has low performance overhead on the master is at large extent because… different consistence guaranty and semantics… and believe me most of Web applications could live with it. They anyway read stale data from… and various performance related features. I’m not sure if MySQL got back to spend significant resources on taking care of Web guys…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…application sooner or later have to decide on couple few questions on how to tackle application performance. These questions are: Should we Optimize Application… couple of boxes to spread Web and Database instances and establish …services around MySQL and LAMP and MySQL is one of them. Plus for large …
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…we can use them for MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 …APC Cache for single node applications If you have just one web server or your data set …. Use Memcached for large scale applications If local node cache is not large enough to cache good …
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… for MySQL Performance Optimization. In fact I probably have to touch it in every second MySQL Consulting… majority of performance problems. Let me illustrate it on simple case. Assuming you have Web application which…as in IO bound case which is large enough for many application classes not to think …
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
… implementation, especially together with LIMIT is often the cause of MySQL Performance problems. Here is what you need to know about ORDER… common use of ORDER BY in interactive applications with large data sets being sorted. On many web sites you will fine top tags… I already wrote about. So what if you have application which can perform search on many different columns, with worse then perfect…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… 16GB of RAM which will be dedicated for MySQL with large Innodb database using typical Web workload what settings you would adjust and… And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications…
