… the triggers # mysqldump … -d -t How to restore mydumper data: Load the schema file Run myloader –threads=x Load the schema-post file I… for different types of restores Strategies on retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… and application is suffering because of stale data. This especially applies to Software as Service …”cold” vs “hot” replication capacity as well as how long replication warmup takes. It is very typical … the peak load and 5 during the normal load. This applies to normal operational load – if you …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… measurement as otherwise we might not catch some long running connections. Now let’s get started. Before … 213 0.0003 1.00 0.00 SELECT data_template_rrd data_input_fields # 16 0xBE797E1DD5E4222F 0.0524 0.6…the output the # MISC part, it tells you how much of “load” is not covered by top queries, we …
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…MySQL database the first advice usually is: – Benchmark! How should we do that benchmark? People usually run… against random generated data. The best way to run a benchmark is replaying the load of your production… slow_query_log=1; SET GLOBAL long_query_time=0; With long_query_time we are logging all…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… on restart. Many people understanding this do not quite recognize how long it takes, and by the fact removing slave read traffic… queries but also how much IO they are causing and how many rows they analyzes. Changes could be in the data which is being accessed by the queries or query execution plans. Side load on IO subsystem Could there be any side load…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… was previously populated to contain value and measuring how long does it take. Test was done on my…seeing several exactly same queries executed during page load is not an exception. For caching these associative…L2 cache if you have large amount of data in long term cache. If you need something like…
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
…There is a lot of misconceptions and misunderstanding on how long such card can last, so I want to… SSD cards, due an internal organization, write more data than it comes from an application. Usually the… Please note we put a quite intensive write load during this hour. MySQL handled 25,000 updates/…
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
… headline was not very catchy and way too long, so I decided to go with the elephant … 10s for page to load“) ? How much loosing one customer cost us? Then, multiply. How much more efficient X … it gets fixed. (b) Company “Ana Lysis” sells data analysis services. Each customer report takes approx. 2h…
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
…Database Data archiving is crucial. There is a difference between data that your application needs now, and data that…that matter to your business: does the website load in the expected time and contain the expected …due to an infinite loop in some code. How long would it have taken us to notice this …
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… more records for same sized logs), how random were data modifications (random updates will need random … time – instead you would need to apply load which is typical for your application, crash …several times you should be able to estimate how long recovery time take and adjust your logs apropriately…
