'Percona Toolkit' Tag

  • Reading RBR binary logs with pt-query-digest

    January 26, 2015

    For purposes of auditing anything that goes on our servers we're looking to parse the binary logs of all servers (masters), as with "Anemomaster". With Row Based Replication this is problematic since pt-query-digest does not support parsing RBR binary logs (true for 2.2.12, latest at this time). I've written a simple script that translates RBR […]

  • Converting an OLAP database to TokuDB, part 2: the process of migration

    September 9, 2013

    This is a second in a series of posts describing our experience in migrating a large DWH server to TokuDB. This post discusses the process of migration itself. As a quick recap (read part 1 here), we have a 2TB compressed InnoDB (4TB uncompressed) based DWH server. Space is running low, and we're looking at […]

  • Re: MySQL 5.1 vs. MySQL 5.5: Floats, Doubles, and Scientific Notation

    January 24, 2013

    Reading Sheeri's MySQL 5.1 vs. MySQL 5.5: Floats, Doubles, and Scientific Notation, I was baffled at this change of floating point number notation. However, I was also concerned about the final action taken: using "--ignore-columns" to avoid comparing the FLOAT/DOUBLE types. The --float-precision option for pt-table-checksum currently only uses ROUND() so as to disregard minor […]

 
Powered by Wordpress and MySQL. Theme by openark.org