… with vanilla MySQL, you will need to aggregate your data. What you want to do is aggregate in ways that optimize the…/XtraDB tables… Optimize For I/O It is pretty much inevitable: if you do this kind of data processing in MySQL, you… a three-part article on data archiving on my own blog a while back. The benefits of purging and archiving…
Comment: About Vadim Tkachenko
June 8, 2006 By 8 Comments
… Group at MySQL Inc. This blog’s name is MySQL Performance Blog and, as you probably assume, it is about misscelaneous sides of MySQL optimization and related stuff. So, if you are MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…). I thought I should write a blog post that will both answer their question…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index…
Post: Looking for High Performance MySQL Interns
September 2, 2007 By 1 Comment
…opening at MySQL Performance Blog. We’re looking for Intern position (with limited compensation) to work on project of MySQL …MySQL Architecture, Unix/Linux Operating Systems and Hardware Performance Optimization, Performance Analysis, benchmarking and load testing plus get your name known in MySQL…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… Marten, it is time for you to get your own blog). I should have replied much earlier but only found time… as well for our performance optimization works – we would like to get much more stats from MySQL and it would be great… on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…the date_id column. There will be another blog post about the usage and performance of the…avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’… throughput over response time, get a good plan optimizer-prune-level=0 partition=ON port=3306 …
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 57 Comments
… assume MySQL would optimize your VIEWs same way as more advanced database systems would. Same as with subqueries and derived tables MySQL 5… have the comments table which holds users comments to the blog, naturally containing user_id which left comment, comment_id and… overhead but only in case they are used with caution. MySQL has long way to go getting queries with VIEWs properly optimized.
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…miss takes. If you approach application performance optimization from the standpoint of response time measurements,…that now. This topic deserves an entire blog post, because there are many subtleties …results to your IO system’s capabilities. MySQL doesn’t have good instrumentation for scientifically…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… differences and are documented in the post. This blog post is not a definitive conclusion about innodb_… Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with …| 0.001000 | 0 | 0 | 0 | 0 | 3 | 3 | | 8 | optimizing | 0.000048 | 0.000048 | 0.000000 | 0.000000 | 0 …
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… that query can’t be resolved by InfoBright optimizer and I need to enable MySQL optimizer. InfiniDB is otherwise was IO-bound, and… more details on InfiniDB scalability on InfiniDB’s blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-infinidb…
