…Web server. In this case you already know who is troublemaker by simply looking at system wide stats. Easier to maintain – Same…Web application and just added some new feature, ie chat application which increases load on your web server…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…extra performance out of the box. Some installations are using RAID0 …wrong and all servers of same configuration will experience the same problem. … especially if you have multiple applications which do not share hardware…provide extra on demand capacity for web servers or memcached quite easily, or…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… to naive implementation. At the same time one would likely get couple of boxes to spread Web and Database instances and establish may… per server and operating cost of $200 per server (space/power/admin overhead) if you have just one server optimizing your application very modest…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… mysql, memcache, sphinx, web services etc. For web applications doing processing in … look inside this black box. Once we know it … functionality to the application. All the same. Once you found …server application there is often the question if it is MySQL server causing the problem or if application…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…applications, which tend to access same data read from database multiple times. Examining MySQL full query logs from many applications seeing several exactly same…pretty low end box we’re…applications If you have just one web server or your data set is small so it fits in memory in each of the servers…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… to be able to get bunch of boxes and use them same as single MySQL server with improved performance and high availability. Of… different consistence guaranty and semantics… and believe me most of Web applications could live with it. They anyway read stale data from… real time is one painful thing to do requiring complex application programming to do efficiently in distributed manner. Of course there…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… you can get a box with 128G of RAM … story heard is typically – Web applications often have significantly …server should be able to handle all traffic from capacity planning standpoint anyway. At the same…applications. I’ve seen applications having no downtime running for years on single MySQL server…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
…application is defined. For example if you would ask me what hardware you need for ecommerce web…box (including search etc). Actually with proper optimization you can even get it to 5000 orders/min from the same single server… it is the same for database server handling custom application – no it is …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… looked up some information on the web about flash memories, and noticed …controller write-back cache does the same thing. PZ: First Indeed writes … moment the server has around 21 GB of memory used for applications (of …So, is the general recomendation also for boxes with larger amounts of RAM, to…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…and update MySQL the same date as release would hit the web. Since that …be application changes which might not be practical for old applications. For the same reasons…next major version out of the box it is not a big …do various cool stuff with Percona Server, Percona Xtrabackup and other Open Source …
