… servers will run a few slave instances each of production database servers and will perform the backups. The write load is… drops to 33% after the first snapshot so keeping a large number of snapshots running is simply not an option. With… the fairly slow gzip-1 mode works well. The tpcc database, which contains a lot of random data that doesn’t…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… can configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is still written… problem before it occurs. For example, if you see a large number of long-running queries in the output of SHOW…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
…, Few quick questions: 1. I have a large innodb database, do I have to export databases from mysql and import them in Percona…
Comment: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… write slow logs to a different disk array on our large databases. So this wasn’t as scary as it may be…-server/5.5/diagnostics/slow_extended_55.html. Rotating the large slow logs requires some special consideration. We will cover that…
Comment: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 13, 2013 By 5 Comments
… out by this when running a mysqldump on a particularly large database the other day… is there anyway to manually set Donor…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a production database backup to our test database so that our test database was consistent before applying the captured…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… it isn’t always obvious how they will affect your database workload. For example: Transaction commit takes approximately the worst packet… ms up to several hundred. This really will open a large window where rows won’t be able to be updated… counter in memcache or redis and only flushing to the database periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…- It’s all about performance. Suppose I have a 2TB database, but maybe my working set is only 500GB. What are… might just be sitting idle? Or what if my database is really large, say in the multi-terabyte range? I might not… this sort of use case, I’m effectively allowing my database to run in memory (not actual RAM, that’s true…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… you’ll learn how to perform typical but challenging MySQL database administration tasks. My focus will be on the following tools… pt-online-schema-change, to run ALTER TABLE statements on large tables without downtime You can reserve your spot for this… some of these tools to solve typical, real-world MySQL database administration challenges, such as: Selecting which queries you should try…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both… there is a non-trivial amount of updates to the database, all SELECT queries, even those participating in read-only transactions…
