…mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to…large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a production database backup to…
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
… InnoDB buffer pool dump/restore and HandlerSocket, our favorite tricks for backup, restore, and provisioning of large data sets, and how to replicate scalably and safely using Tungsten Replicator with parallel apply. Bring your big data questions to this…
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
…data copying around between MySQL boxes. We had prepared well and had measured how fast we could copy the data… RAID is powerful enough. This applies to large Innodb tables with not overly fragmented …to restore all 50 servers from backup… in parallel. Will you backup system will be able to restore…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…to restore data from backup which can be far from being enough to restore the whole system to…to MySQL bugs or wrong use. Interesting enough very few people have their data recovery practices ironed out so they can answer how…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… important is that nested-loop joins on large data sets are very expensive. If MySQL supported sort-merge or hash joins, you… of data processing in MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL… But you still have to think about how to avoid enormous tables that are hard to maintain, back up, and restore. And the partitioning…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…Furthermore besides MySQL table_cache Innodb maintains its own (called data …Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB: Doing recovery: scanned up to… not being that large liability even with large number of…. I guess Heikki knows how to implement …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…data, higher concurrency, background flushes while on the drawbacks side we see significantly large table size (especially if data size is close to…how to handle it, or be able to learn it. It is also important to adjust processes as required to…to do restore for Innodb. On large…in the MySQL server – …
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
…apt metaphor for how the tool…to simulate the situation, Stewart suggested we use a transactional load against a large number of tables. We were able to…to use the following command to execute the test: ./dbqp.py –default-server-type=mysql –basedir=/path/to… try to restore it…. to produce test data …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…to copy files. Fast Recovery Recovery time is as fast as putting data back and standard MySQL…to do atomic snapshot of many volumes. Lets speak a bit about how…to hold modifications during backup process – I’ve specified 16GB in this case. If your undo size is not large… will need to restore slaves as …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…to restore a part of the data set, when it’s time to do a full data restore, more tables means longer restore times. Deciding to…data etc. Read more in my > Why MySQL Could be slow with Large Tables article. Deciding whether or not to…
