… of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation… in throughput starting from 256 threads. But Percona Server’s scalability is the same as in the previous benchmark. The overhead…” optimization in MySQL 5.6 are nice ways to improve scalability in highly concurrent workloads. We also have plans to combine…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory… reported as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory… reported as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… allocation is an costly operation and if memory allocator has scalability problems (like allocator from glibc) this will notably slowdown MySQL… direct malloc() call, but rather goes through the InnoDB heap layer – so InnoDB allocates heap area and then creates requested block(s… helps MySQL 5.5.30 to fix issues with malloc scalability but still scanning of the transaction list causes performance drop…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL…:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential Innodb successor. A “MySQL Network… version only. An Innodb Plugin is announced and will be separate from MySQL Server, providing a more scalable Innodb version with more features…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
The link http://www.codership.com/en/content/benchmarking-write-scalability does not work anymore? I am running mysqlslap against a…-indexes=3 –auto-generate-sql –csv=/tmp/mysqlslap_3index_innodb.csv –engine=innodb –auto-generate-sql-add-autoincrement –auto-generate-sql-load…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
Vadim, can you confirm negative scalability with InnoDB compression and multi value inserts ?
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… to let them know the fix is now out for Innodb scalability bug and they can rerun the test to see if… – version gap is too large to only map it to Innodb scalability patch. 2) Speedup for 5.0.32 for large number… tps. 4) The bad news are – we still have massive scalability drop with increasing concurrency – going from 10 to 20 concurrent…
Post: Returning to InnoDB scalability
July 28, 2006 By 42 Comments
I’m again returning to InnoDB scalability and related bug #15815 as it hurts many users and … with “buffer pool” mutex, which protects innodb_buffer_pool. In details, for each scanned row InnoDB calls block_get / block_release functions… 240/11 ~= 21 times, and if before we had negative scalability, currently scalabilty factor is 2.9 (the result with 4…
