… 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…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with… lock-out or waiting, and the specific implementation has a scalability bottleneck on multicore servers. Mark Callaghan has done much more…, it wouldn’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and it…
Post: mysql-proxy, urgh performance and scalability ?
June 9, 2009 By 44 Comments
…, and let’s look on response time (for 1 thread). MySQL per-request statistics: min: 1.31ms avg: 1.51ms max: 5.30ms approx. 95 percentile: 1.56ms Proxy+MySQL per-request statistics: min: 2.04ms avg: 2.86ms max… consider if you want to run Query Analyzer with MySQL-proxy on your MySQL Enterprise setup. There is alternative – Dormando-proxy, which…
Post: MySQL and SSD | Percona XtraDB Cluster talks
September 13, 2012 By Leave a Comment
… solution for MySQL“. I will give introduction in MySQL clustering and show how Percona XtraDB Cluster solves HA and scalability problems. MySQL and SSD… Rate prices end this Saturday. If you are working with MySQL and you are in New York on 1-2 Sep…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… something obvious in MySQL settings as well as to let them know the fix is now out for Innodb scalability bug and they can rerun the test to see if there are any difference. Recently Tweakers.net published comparison of MySQL… and will be different in other benchmarks) we can see MySQL scalability problem with high number of CPUs and high concurrency is…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… in production, that’s why we did not escalate MyISAM scalability question. This time working on the customer system we figured… not fully fixed by changes done in MySQL 4.1 As Monty explained us in MySQL 4.1 the change to key… it in more details. Note however even in this case scalability is far from perfect giving only 1.5 times gain…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… were a lot of custom technologies created for caching or scalability issues MySQL could not solve well. There are inhouse and opensource… presented Storage Engines targeting certain workloads. PrimeBase is working on scalable blog streaming to make it possible store large blobs such… and running fast and Scalability on the scale of Big Table with Map Reduce. Indeed I think MySQL Replication usage will reduce…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only workloads. Workloads which got…. This is why it is important to test performance and scalability for your application on your hardware if you really want… 12 physical cores and 24 threads, which is almost perfect scalability. So there are workloads where the problem is solved and…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… I wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (… auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-table-…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… article also has very interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on Linux with many… looks like it is not the case with Solaris. The scalability is not perfect but at least there is gain not… was working with article authors advising them how to tune MySQL and what is the reason for negative scalability etc.
