… live server. Mysqldump works well for this, but can quite slow on larger schemas. One of the downsides to mysqldump is the… structures in place. Fortunately, this can be done easily using mysqldump –no-data. Now, enough with the theory, here is the…/2013-06-03_11-30/orig) Get the table structures: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… amount of ram prevents double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…: Q: Can you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, it’s…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… spikes and produces a very constant and predictable result. vCache vs. FlashCache – the basics Once I’d determined that configuration C… within acceptable bounds. This is, however, only a hypothesis. vCache vs. FlashCache – dirty page threshold Finally, we examine the impact of…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
(This is part one of a two part series) Over the past few weeks I have been looking at a preview release of Virident’s vCache software, which is a kernel module and set of utilities designed to provide functionality similar to that of FlashCache. In particular, Virident engaged Percona to do a …
Comment: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 13, 2013 By 5 Comments
seems i was caught out by this when running a mysqldump on a particularly large database the other day… is there…/Desynced status and to exit the State so that manual mysqldumps can be run for other reasons – much akin to doing…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
The point at 685 sec when InnoDB performance drops, is that when data doesn’t fit all in RAM anymore? I would in general expect to see benefits from TokuDB when workload is diskbound. You could artificially reduce InnoDB buffer pool (and corresponding Tokutek setting) to have more SSD vs RAM.
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, particularly when using a blocking SST method like rsync or mysqldump. So, flow control kicks in when the recv queue gets…
