June 20, 2013

Post: ZFS on Linux and MySQL

… 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

… 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

…, 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!

… 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

… 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!

… 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?

… 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

…- 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

… 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

… 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…