… To put it another way the tools are designed to provide insight about the business process, hence…) server uses data stored in an RDBMS. These systems trade the performance of a multidimensional store for… Focusing on ROLAP. This is the MySQL performance blog, and as such an in depth discussion of…
Post: Using MySQL as a Queue, and Free Percona Live Tickets
September 15, 2011 By Leave a Comment
… it’s a guest post over on the Engine Yard blog: 5 subtle ways you’re using MySQL as a queue…! Excerpt from the blog post: Many people realize the difficulties in building a good job queue or batch processing system, and try not to create one inside MySQL. Although the job queue is a great design pattern from…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
…much everything possible in our book and on this blog. The problem is, sometimes an expert human’s …for optimal config is hard. Remember how Falcon’s designers said Falcon was going to be self-tuning? Now…crontab format, of all things! Oracle and some other systems show that it can be done, but ask an…
Post: Sharding and Time Base Partitioning
March 14, 2008 By 12 Comments
… data belonging to same user is equal. Consider Blog or Forum as example – most likely few last … writes which can be significant depending on your design. It does not only have to be active …sense to separate data based on its importance for system operation – for example if page versions data is …
