MySQL can be deployed in several ways, and that means you … popular, sooner or later you have to think about write scalability, and implement sharding ultimately. I will give a talk on…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
Post: Webinar: Best Practices for MySQL Scalability on May 1
April 30, 2013 By Leave a Comment
… for MySQL Scalability.”[/caption] If you have not already done so, I encourage you to register for my “Best Practices for MySQL Scalability” Webinar… Webinar! *** More info: MySQL scalability depends on getting many things right including the architecture, hardware, operating system, MySQL version, MySQL configuration, schema design and…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… the same transaction. Why is that a major problem for MySQL scalability? The scan is performed under kernel_mutex (or trx_sys… combined with the read-only optimization in MySQL 5.6 to achieve even better scalability while removing the read-only limitations. Let… read-only) transactions. In this case MySQL 5.6 scalability goes back to the good old MySQL 5.5 times and we see…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…_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… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… from MySQL Server, providing a more scalable Innodb version with more features. Gearman and MemcacheD storage engine plugins are available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… operation and if memory allocator has scalability problems (like allocator from glibc) this will notably slowdown MySQL-transaction creation and many threads… also by bad 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…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…_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… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=9 –oltp…
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… write 100,000 queries in about 50-60 seconds to mysql 5.1 and in about 6-9 seconds on mariadb…=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server…
Post: Percona white paper: Forecasting MySQL Scalability
November 16, 2010 By 6 Comments
… have just published Percona’s latest white paper, Forecasting MySQL Scalability with the Universal Scalability Law. This is essentially a streamlined walk-through… metrics can provide amazingly rich insight into system performance and scalability, in combination with Little’s Law and queueing theory. These…
