I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… tuples fetched, and N is the buffer size. In MySQL 5.6 the buffer size used by MRR can be controlled by… a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5.6 and… tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). I did not use Scale Factor of 40 (InnoDB dataset size ~95G), because…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… on TPC-H dataset (InnoDB tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). Note that query cache is disabled…/ join_buffer_size=6M & mrr_buffer_size=6M MariaDB 5.5 Hash Join Disabled w/ join_buffer_size=4M & mrr_buffer_size=4M Created… BKA relies on both the join_buffer_size and the read_rnd_buffer_size/mrr_buffer_size and both of these buffers should…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
… most obvious one. MySQL (and systems in general) do not scale perfectly with numbers of CPUs and number of concurrent requests… scalability numbers depend a lot on the system scale, software and workload. Data size impact There are different type of applications out… a scaling through copying not the amount of data you have in the system. Wikipedia is a similar case – the data size…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
… well. So how does System size come in play here ? Well it is system size and scale what may define how much performance you need to squeeze out, and also how your scaling is set… however implies two things – first you can scale system by adding more servers, because scaling up and purchasing more and more powerful…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… to check if there are any restrictions on Innodb Buffer Size you can use. Typically you would see restriction applying only…. I would put this to 256M for small sized boxes to 5% of memory size on the big boxes, though it can… can increase it a bit to be on the safe size and scale appropriately. The third important memory consumer would be OS…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… lot of attention such as Sysbench and DBT2/TPC-C scale pretty well a they got a lot of attention, there can be other quite typical workloads however which do not scale that well. This is why it is important to test… key defined on (group_id,deleted) This pattern of medium size IN lists is typical for a lot of modern applications…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max… to access data and retrieving from OS cache is not scaled. READ_KEY_POINT_LIMIT Query: SELECT name FROM $tableName WHERE… is maximal that can be reached for this query. Falcon scales pretty bad and there is a big room for optimization…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… increasing data size? Here is where people start to scratch their heads. They naturally assume they need to scale more, we… cover up the databases inefficiencies to ensure that our application scales. The problem is for some applications, we are fixing symptoms… of increasing data size? Here is where people start to scratch their heads. They naturally assume they need to scale more, we…
Post: Understanding Performance Optimization Terminology
March 2, 2009 By Leave a Comment
… the high volume applications we assume scaling to larger amount of users, larger systems, larger database size and this is what I… hear “It does not scale” applied to the application on same system as load or database size increases as well as to…. Your application may be performing well and scaling to insane load and data size but If I can do the same with…
