…MySQL replacement). There is a lot of “MySQL Community” focused keynotes. Good coverage of MySQL Alternatives including keynotes for Drizzle and MariaDB. MySQL 5.5 replaced MySQL…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL bug… problem for MySQL scalability? The scan is performed under kernel_mutex (or trx_sys->mutex in 5.6) and that is one of the…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… scalability of glibc malloc itself – jemalloc helps MySQL 5.5.30 to fix issues with malloc scalability but still scanning of the transaction list causes performance drop = MySQL 5.6…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand….g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected. So while… read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the list of transactions, its applicability is…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… complicated and performance of MySQL is often the problem even for medium scale sites. As response to these things few things happen – MySQL kept… ? From MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy to… terms of getting it up and running fast and Scalability on the scale of Big Table with Map Reduce. Indeed I think MySQL Replication…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…performance. Investigating Innodb Scalability Limits You may have heard Innodb has limited scalability with multiple CPUs and some of these were fixed in recent MySQL… MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… the system to predict in performance, the model baron has published for example is good for measuring scalability of the system as concurrency… out Thinking Clearly About Performance by Cary Millsap. So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare it to estimated (or benchmarked) system performance…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write some simple steps… you quite a lot of what you should expect from the system. What I usually look for MySQL is performance in random reads… advantage of them unless you can get multiple outstanding requests. Performance with 64 threads was 2334.63 Requests/sec which is perfect scalability…
