…DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD…to handle process scheduling and timing much differently than traditional hardware, and I’ve …MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…start the snapshot while holding a “flush tables with read lock” and the flush operation…Better availability and disk usage On purpose, I allocated mirror pairs using drives from different controllers. That … Linux is a very interesting solution for MySQL backup servers. All backup solutions have an…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…disk. This has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…maintained in separate tables and there also exists a users_groups table to define the … with PXC and Galera is no different in that there are trade-offs,…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL…mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… *.ibd, disk image, etc.) and a table structure. Indeed, there is no information about the table … a table identifier. We will need the table id to find indexes of the table. mysql> select * from SYS_TABLES…notes: The generated structure differs from the original structure of the table, but it is good…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…0.0951 ms range per/cmd InnoDB MySQL Select (same table): Fetching [1,000,000] items: 441573 …differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06 ms/op) MySQL… of warmup time to application Cost of disk space on database server Now, there are …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…’t make 5h run. After 3h the disk is full, and InnoDB data size … review different workload (which actually is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `…insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…’s still one noticeable omission: pt-table-sync. It’s still unclear if…, this can take a lot of disk space, but it allows you to “…connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk –… their run-related options a little differently. This magic is gone now: both…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. …a billion-row (non-partitioned) table will, at worst, hit the disk only 5 times. (Usually 4… partitioned, hence slightly faster. Conclusion: Not much difference. Yes, DROPping an ‘old’ partition is very …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…) DIMM {OUT OF SPEC} Other … # Disk Schedulers And Queue Size ############################# sda | [deadline] …with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions…connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = …
