… is getting closer to PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that… installation base. Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0… in timeline (from 0 to 1800 sec): I am not sure how to explain it, that with …
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
…MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables you to…it to verify replication Peter will discuss using it to verify upgrades I’ll show how to use it to …, get the source code from Launchpad, and file bug reports on Launchpad. PS: in addition to …
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… that get changed that might have unforeseen consequences (one of the reasons why distributions like to pin release versions.) Given MariaDB is MySQL with patches, I’m not sure quite how much that gains, or…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…MySQL version installed already, but if it’s not any of these releases, you will need to…output you can learn how to run configure command, which needs to be done prior to compiling the …to log only queries doing full table scans you would need to set this to “full_scanâ€, while in order to get…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… about how to make MySQL replication reliable, part of which is to eliminate temporary tables….What you see depends on your version of MySQL, because the logging of stored …to me that there’s no way to get the CREATE TEMPORARY TABLE statement to be logged inside the transaction. And when it comes to…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… to physical address (at a certain level) so when writing a file, file system decides how to …versions of them) might be using different units for these options so you should refer to a manual on your system to… want to get to the beginning of next stripe element i.e. 256th kbyte so we need to offset …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to parallelize. As you know, MySQL doesn’t do intra-query parallelization, so ETL jobs written to rely on SQL tend to get… we’re doing here starts to look like a hillbilly version of Infobright, which I’ll… you still have to think about how to avoid enormous tables that are hard to maintain, back up…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
…how to use MySQL not just if it should be used or not. There are many applications when MySQL…version and solve things yourself or use third party support, which indeed works as MySQL…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…with Flexviews. It continues with an overview of how to install and run FlexCDC, and concludes with …be able to read the binary logs of the version of mysql it ships with (and previous versions) so … if this is a MySQL slave transaction_isolation=READ-COMMITTED You can get FlexCDC directly out of …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…In MySQL 5.1 and newer with the InnoDB plugin, it’s easy to figure…-plugin InnoDB versions, you can’t reliably figure out what connection is to blame … # Make sure the disk isn’t getting too full. avail=$(df -m -P /root/tcpdumps… and I am still stumped as to how a SELECT-only transaction can possibly…
