… 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 Scalability for Facebook Application Developers
July 5, 2009 By 3 Comments
… of FbFund educational seminars I will give a talk on MySQL Scalability for Facebook Application Developers. We have been working with number…
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: 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: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… model baron has published for example is good for measuring scalability of the system as concurrency growths. In many cases however… which include both latching as well as inevitable application specific scalability restrictions, such as row level locks. There is also a… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…_5_6_10# sysbench –test=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size=1000000 –num… actually growing with increased contention even though MySQL 5.6 is positioned as improving scalability over MySQL 5.5. Also number of expected…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with no problems in most cases…, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even… both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
… for MySQL A free, open-source solution, Percona Server for MySQL is an enhanced drop-in replacement for MySQL, offering breakthrough performance, scalability, features… demand excellent performance and reliability from their MySQL database server. Compare Percona Server to MySQL. Performance Percona Server’s performance is exceptional…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
… PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables… Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables… Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text…
