… to let them know the fix is now out for Innodb scalability bug and they can rerun the test to see if there… tps. 4) The bad news are – we still have massive scalability drop with increasing concurrency – going from 10 to 20 concurrent… will be different in other benchmarks) we can see MySQL scalability problem with high number of CPUs and high concurrency is…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…history you may think Key Cache scalability was fixed with new Key Cache in … +——————————————————————————————-+ | CACHE INDEX test.a IN test_a; | | CACHE INDEX test.b IN test_b; | …
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… for MySQL. While my far goal is the performance and scalability testing before I wanted to look at basic transactional properties such… used default isolation mode which is REPEATABLE-READ for this test. Test 1: Solid, deadlock detection, default (OPTIMISTIC) concurrency control. CREATE TABLE… used. Quite possibly it is a bug which will be fixed in the future, if not it will be serious handycap…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… there are scalable algorithms to deal with it. I would expect Monty to implement one of them. To do the test I… tables/sec – This indicates the “fsync” is lying on this test system as default sync_frm option is used. With default… well. So the problem is real and it is not fixed even in Performance focused MySQL 5.4. As we can…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…. The modeling I performed is Universal Scalability Law modeling, which can predict both software and hardware scalability, depending on how it is used. In brief, the benchmarks are sysbench’s read-only and read-write tests, and… broken; it would mean that there is potentially something to fix in the server at high core counts. Without the model…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
Recently I wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark… –thread-stack-size 32K –init-rng on –validate off –test oltp –oltp-test-mode complex –oltp-sp-name –oltp-read-only off…
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
Recent scalability fixes in InnoDB and also Google’s and your SMP fixes almost made InnoDB results acceptable in primary key lookups queries…, dropping down just after 8 connections, si I decided to test MySQL-5.1.30 with standard InnoDB. It was better…
Post: Opening Tables scalability
November 21, 2006 By 27 Comments
… is possibly expensive operation, but really it is only great test case for general MySQL problem. During warmup process I noticed… operation if you care about scalability. MySQL has same problem with key buffer but that was fixed in MySQL 4.1, this… and having 50+ developers this should have been fixed. Until this is fixed it is especially important to keep your table_cache…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than treat each defect as an individual case, is there any performance testing…us greatly to spot scalability problems and find fixes for them. The work continues. I believe improving scalability is a …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We also want… the difference afterwards. Or we might have a test server to run on. It varies widely; …can decide which things to have us fix, which to fix themselves, and which to just ignore. …
