… to the MySQL 5.5 release. This should help MariaDB be faster and more scalable, as well as adding a lot of nice… versions of MySQL that suit different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL. With this release… downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking… upgrades I’ll show how to use it to forecast scalability and performance The new Percona Toolkit release is available for download…
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…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL version upgrade can have both of these… both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL history…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… processing performance Shard-Query + ICE scales very well up to at least 20 nodes This post is a detailed performance analysis of what… this, but it requires further investigation. Next I compared the performance of 20 m1.large machines cold, versus hot. I did not… being overloading and provides a scalable average response time under increased concurrency. Another queue in front of the storage nodes is probably…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
…it’s always had, and that this can cause scalability problems and locking, but there have been some important…point in the server. Now that’s gone. As of MySQL 5.5, the query cache mutex isn’t hit… It didn’t improve anything in the server’s performance, but it improved transparency to the user. This …
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… at performance of Irwindale based Xeon and Sun T2000. Results are close to the ones I had in MySQL Performance Landscape presentation – neither of them… observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on Linux with many connections with increasing number of CPUs…
