… uses simple MySQL functionality which is unlikely to be affected. If you’re something like SELECT name FROM users WHERE id=5 you can probably go to the earliest MySQL version and still get same… and made it to caught up you can use mk-table-checksum to ensure data is the same. It is possible some…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… have you ever wondered what servers are in your MySQL replication hierarchy? We have, too. As consultants, a … are important to know — if we run a checksum on the non-cloud servers, for example, we …, is not read_only Filters replicate_wild_ignore_table=foo%.mount% Binary logging ROW Slave status 0 …
Post: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
… specify “–recursion-method dsn=DSN-TABLE” when running pt-table-checksum, where “DSN-TABLE” is a DSN specifying the above DSNs table. For example: –recursion-method… DSN table, else pt-table-checksum will not check them for differences. Here’s the abbreviated output of a real run: $ ./pt-table-checksum h…-05T14:02:17 0 0 0 1 0 0.019 mysql.db … 10-05T14:02:18 0 0 3 1 0…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…workload was having an effect on the test tables between crash/recovery/validate cycles. To examine … this option as many tests might have points where we’d like to see what is …master-slave checksums after the master has crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql-5.5 …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql …-table-checksum periodically (i.e. once a month) and make sure your servers data stays consistent. Checksumming…means where you may have been locked for hours where you had many non-transactional tables, …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.01 sec) mysql> SET expand_fast_index_creation…ALTER TABLE are ignored to enforce uniqueness where necessary when copying the data to a temporary table; ALTER TABLE and OPTIMIZE TABLE always process tables containing…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… be network (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware problems and few others… where LVM or similar techniques can help you a lot) or skip bad events as described and when use Maatkit mk-table-checksum to check what tables are out of sync and when use mk-table-sync to resync them…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
…_general_ci Checksum: NULL Create_options: Comment: InnoDB free: 1591296 kB 1 row in set (0.27 sec) Table with rather small… in this table and see how long does it take: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select count… md5(rand()) values) : mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select count(*) from sample where j like “5%” lock…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had a… testing MySQL. My goal was to simulate as much IO as possible so I use Sysbench to get 300Mil rows table and… so I could not investigate where exactly CPU is wasted. My first obvious quess was Innodb checksumming (innodb_checksums=0) and indeed that…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… to know is howto track down where the bottleneck is… I’ve …table‘, ’0′ ‘Com_begin’, ’0′ ‘Com_change_db’, ’155′ ‘Com_change_master’, ’0′ ‘Com_check’, ’0′ ‘Com_checksum…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
