… all of InnoDB‘s ACID-compliant design and advanced MVCC architecture, and adds features, more tunability, more metrics, more scalability on many… InnoDB RW-lock fixes Improvements to scalability for systems with 8+ cores. documentation Buffer pool fixes Improvements of buffer_pool scalability. documentation innodb_buffer…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… most interesting: Further Scalability improvements Yasufumi Kinoshita did number of interesting benchmarks stress testing other areas in Innodb than buffer-pool which… I still see Innodb having serious scalability problems in some environments with 4+ cores so it is still important. IO Scalability patches Mark…
Post: InnoDB auto-inc scalability fixed
September 26, 2007 By 18 Comments
There was long played scalability issue with InnoDB auto-increment field. For details check Bug 16979. In short … causes serious scalability problems, and in our consulting practice we had a lot of customers who was affected by InnoDB auto-inc… is the fix introduces new system variable innodb_autoinc_lock_mode which determines behavior of InnoDB for tables with autoinc. I do…
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…:autoextend \ –innodb_buffer_pool_size=6GM \ –innodb_additional_mem_pool_size=20M \ –innodb_log_file_size=128M \ –innodb_log_files_in_group=2 \ –innodb_log…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23…_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… engine functions and we use it to see performance and scalability in this simple cases. We also use CPU bound workload… MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread… Starkey’s comments in Part 2). There MyISAM shows bad scalability with increasing count of thread. I think the reason is…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
… for now is support of InnoDB-plugin, which as we know performs much better than standard InnoDB ®. So what is so interesting… the latest developments in computer science to produce fast and scalable synchronous replication solution that “just works” for databases and similar applications”, which I think they have success in. Implementing fast, scalable and working group communication and transaction manager is the art…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… to work together to produce better talk instead. Hidden Innodb Tuning Options Innodb Storage Engine has a lot of tuning options hardcoded… can get any additional performance. Investigating Innodb Scalability Limits You may have heard Innodb has limited scalability with multiple CPUs and some of these…
Post: MySQL 5.5-m2 scalability
February 28, 2010 By 17 Comments
… UC 2010 in April. So let’s make quick on scalability characteristics we should expect from new release. I made sysbench… couple conclusions we can come with InnoDB now can scale up to 16 threads pretty well InnoDB can keep load up to… concurrency on rollback segment (which is global shared structure in InnoDB) sysbench command for reference: ./sysbench –test=oltp –oltp-table-size…
Post: Opening Tables scalability
November 21, 2006 By 27 Comments
… Tables” stage was taking long. Part of the problem is Innodb is updating stats on each table open which is possibly… opens are serialized. Do not think however it is only Innodb problem. I’ve seen similar problems with MyISAM – these also… blocking physical IO or network operation if you care about scalability. MySQL has same problem with key buffer but that was…
