… Millsap. So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S… makes it very IO bound. So what If I am planning for load growth and need to have system handle another…
Post: Percona white paper: Forecasting MySQL Scalability
November 16, 2010 By 6 Comments
… I have just published Percona’s latest white paper, Forecasting MySQL Scalability with the Universal Scalability Law. This is essentially a… J. Gunther’s book Guerrilla Capacity Planning, with examples to show how you can apply it to MySQL servers. One thing alluded to… feature request for Percona Server to add these metrics for MySQL users.) I’ll probably follow this up with another blog…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… Partitioning Sharding is inevitable if your write workload exceeds the capacity of a single server (or if you’re using replication… making a mistake. Watch out when you do your capacity planning. Don’t get fooled into calculating the wrong thing… save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
… correct at least to the order of magnitude. Seriously in MySQL Consulting practice it would not be exception to have 1… need estimates, however we need to spend time doing serious capacity planning, probably look at real data try tunning sample queries etc… about some techniques and formulas which you can use for capacity planning in one of the next articles.
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even… SELECT queries on both new and old MySQL installations and check result set, explain plan and execution time, reporting you on all… measuring its capacity) Setting up the Slave(s) If you want to minimize downtime it is best to use MySQL Replication for…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what…concurrent traffic on the slave can affect replication capacity a lot. Checking traffic for changes with… accessed by the queries or query execution plans. Side load on IO subsystem Could there…
Post: Announcing Percona Live Washington DC MySQL Conference
December 7, 2011 By Leave a Comment
If you are close to Washington DC, you should plan to attend our Percona Live event on January 11th at … MySQL-related topics. This event will not be as large as some of the other events we’ve run, with a capacity… regional events periodically to try to make sure top-quality MySQL events are more accessible to all, not just the privileged…
Post: Getting History of Table Sizes in MySQL
December 8, 2010 By 13 Comments
… component for capacity planning and simply watching the growth of space used on partition is not very helpful. Now as MySQL 5.0…’re looking to keep it completely inside MySQL you can create appropriate event in MySQL 5.1+ Unless you’re having millions… have it handy. If you’re having large number of MySQL servers, especially in Sharded environment it makes sense to modify…
Post: The four fundamental performance metrics
April 27, 2011 By 15 Comments
… and aggregate metrics of activity on a system such as MySQL. In the best case, we want to know everything about… with the Universal Scalability Law, perform queueing analysis, and do capacity planning. And we obtained all of this without needing to analyze…
Post: Performance or Stability ???
April 1, 2011 By 16 Comments
… one, how much I can count on in terms of capacity planning ? In case this is typical OLTP system I will have… depends of response time your application can tolerate. In the MySQL Benchmarks Vadim Posted we see there are a lot of…
