… 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…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
… so on. You can use this information for historical metrics, capacity planning, troubleshooting, and monitoring to name just a few. The tcprstat… outbound packet. For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a query’s response…
Post: Announcing Percona Toolkit Release 2.0.3
February 6, 2012 By 2 Comments
… decisions when there are problems or when doing things like capacity planning. Brand new pt-stalk, courtesy of Daniel Nichter. This tool…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… the reasons for this and the wrench it throws into capacity planning). If we zoom in on a particular sample — say the…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… to catch up. Need to replication capacity is not only needed in case you’re planning to use replication to perform system… and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS…. This gives us replication capacity of 1/0.37 = 2.70 This method should work with original MySQL Server in theory, though…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… hardware) the write capacity of a database server. In term of write capacity here are you choices. Write capacity MySQL replication Fair Master-Master… NDB Cluster is an integrated sharding environment, if you are planning for a growth that will need sharding (splitting the database… level is summarized in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… is far from reaching its replication capacity. I would suggest measure and monitor your replication capacity (how long will it take a…’re planning to operate without slave every so often, meaning one server should be able to handle all traffic from capacity planning standpoint… the availability of the application is only related to the MySQL redundancy for very high quality/high scale applications. I’ve…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… is the smaller portion of full write capacity you will be able to pass through the… execution time of queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries… do not assume very short lag time when planning your application. Having application which can adapt …
Comment: Adaptive flushing in MySQL 5.6 - cont
September 11, 2012 By 13 Comments
… be varying up to innodb_max_io_capacity (which is being renamed to innodb_io_capacity_max) to prevent it getting there… when that work is done. While this is usually a capacity planning failure or overload if it happens in production we do… an official Oracle view consult a PR person. James Day, MySQL Senior Principal Support Engineer, Oracle.
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… 2 servers directly is faster and we had a spare capacity which we could use. First we ran the check using… had to think about rollback plan if something goes wrong and we need to go back to MySQL 5.0 on the… being trivial. This was the best choice as with New MySQL version upgrade involves new Operating System and hardware and any…
