2571 Commits

Author SHA1 Message Date
Daniel Nichter
07420ff78e Don't crash on empty tables with --chunk-size-limit=0. Don't crash trying to print MySQL warning. Finish updating (all the important) tests. 2011-10-15 17:47:56 -06:00
Daniel Nichter
c28461aaef Move retry_timeouts.t tests to error_handling.t and remove retry_timeouts.t. Change max_chunk value for checking slave diffs to avoid infinite wait for nonexistent chunks. Use undef instead of 0 for skipped chunks. Make lock wait timeout skipped++ instead of errors++. 2011-10-15 15:45:11 -06:00
Daniel Nichter
23e9b91d78 Update replication_filters.t and resume.t. 2011-10-15 15:03:25 -06:00
Daniel Nichter
48fb4baa7c Use 'h=localhost' if no DSN or DSN options given. Remove unused DSN parts (D and t) and don't copy some parts. Move issue_947.t tests into standard_options.t and remove issue_947.t. 2011-10-14 07:59:43 -06:00
Baron Schwartz
5bc577920b some documentation updates etc 2011-10-13 16:47:01 -04:00
Daniel Nichter
60d8b1a710 Update issue_388.t, issue_47.t, issue_602.t. Rename issue_81.t to error_handling.t. Move issue_69.t tests into basics.t and remove issue_69.t. 2011-10-13 12:46:44 -06:00
Daniel Nichter
f7c85d547d Update chunk_size.t. Don't update progress if progress is disabled. 2011-10-13 09:45:26 -06:00
Daniel Nichter
964bb094a0 Get row estimate from NibbleIterator. Use user's index over MySQL's index when --where is given. 2011-10-13 09:23:53 -06:00
Daniel Nichter
083fb1b8ca Make --explain cummulative. Update char_chunking.t. Reword checksum query comments. 2011-10-12 11:22:13 -06:00
Daniel Nichter
271cd850d6 Enable --create-replicate-table by default, and create the repl db too. 2011-10-12 08:35:08 -06:00
Daniel Nichter
ce9d7d461a Re-implement --explain. 2011-10-11 12:33:36 -06:00
Daniel Nichter
7da33234f5 Fix bug 821717: pt-tcp-model --type=requests crashes. 2011-10-11 08:31:42 -06:00
Daniel Nichter
b2f92391a7 Fatal error if slave dies. Make Cxn::connect() if dbh id dead. Sort slave lag properly and use Cxn instead of dbh in ReplicaLagWaiter. Check master cxn before keepalive. Sleep N+0.25 waiting for chunks. 2011-10-10 10:56:08 -06:00
Daniel Nichter
eae742ee78 Timestamp all output. 2011-10-07 11:58:41 -06:00
Daniel Nichter
e89def56b8 Catch and handle 'Data truncated for column' warning. 2011-10-07 11:29:10 -06:00
Daniel Nichter
290e931c57 Unify SET stuff for new cxn. Add --lock-wait-timeout and set innodb_lock_wait_time. 2011-10-07 10:38:36 -06:00
Daniel Nichter
59ff1c6907 Catch and retry certain errors. 2011-10-06 13:05:43 -06:00
Hartmut Holzgraefe
1fc403293d always explicitly set REPEATABLE READ isolation level
https://bugs.launchpad.net/percona-toolkit/+bug/869005
2011-10-06 11:23:00 +02:00
Daniel Nichter
bd900c5ab8 Implement --quiet. 2011-10-04 10:50:20 -06:00
Daniel Nichter
830f855c05 Fix race condition between replicate and replicate-check. 2011-09-30 09:58:33 -06:00
Daniel Nichter
b3cfd659b1 First basic tests. Reset global var. Add post_pipeline to PercoaTest::no_diff(). 2011-09-29 17:54:38 -06:00
Daniel Nichter
78b4f36d71 Don't require DSN. Begin rewriting docs. 2011-09-29 13:02:14 -06:00
Daniel Nichter
ed68f3ef5c Exit 1 if diffs. 2011-09-29 12:21:32 -06:00
Daniel Nichter
c794f5e119 Implement --replicate and --replicate-check at same time. Pass where arg to find_replication_differences(). 2011-09-29 12:16:35 -06:00
Daniel Nichter
c4092295a5 Re-implement --replicate-check. Add --quiet. Update find_replication_differences(). 2011-09-29 10:46:22 -06:00
Daniel Nichter
206ac93214 Working --resume. 2011-09-29 09:17:36 -06:00
Daniel Nichter
929000cfdd Partial --resume implementation (work in progress). 2011-09-28 11:33:12 -06:00
Daniel Nichter
d4b5409492 Implement --[no]empty-replicate-table (default: yes). 2011-09-27 12:05:42 -06:00
Daniel Nichter
af17abb7ed EXPLAIN next ub sql. Catch Ctrl-C between nibbles. Use NibbleIterator member functions instead of args. 2011-09-27 10:40:11 -06:00
Daniel Nichter
c9e8444166 Handle one-chunk tables. Chunk tables w/o indexes if they're small enough. Check index for every chunk. Check chunk size if ub and next_lb are equal. 2011-09-26 11:38:35 -06:00
Daniel Nichter
4e8b00b4cc Update NibbleIterator in pt-table-checksum. 2011-09-23 17:41:49 -06:00
Daniel Nichter
9f3e05691c Detect infinite loops. Use best non-unique index. Disable chunk size limit if chunk index is unique. 2011-09-23 17:33:23 -06:00
Daniel Nichter
07cb6010a2 More repl table columns: chunk_time, chunk_index, lower_boundary, and upper_boundary (those two replace boundaries). 2011-09-23 10:13:57 -06:00
Daniel Nichter
b783470aaa Implement table progress. Adj rate and chunk size only if nibbled > 0 rows. Always use --chunk-size if --chunk-time=0. 2011-09-23 08:54:58 -06:00
Daniel Nichter
1d47fe29b8 Use CleanupTask to close all dbh nicely. Don't do after_nibble stuff if chunk was skipped. Don't pass %common_modules. 2011-09-22 12:11:33 -06:00
Daniel Nichter
60c28c0b30 Remove --[no]optimize-xor; it's always on now. Add prefix TS with day and month. 2011-09-22 10:47:54 -06:00
Daniel Nichter
380cf4b0bd Init talbe 2+ chunk size based on total server rate. 2011-09-22 10:13:44 -06:00
Daniel Nichter
bbae1ba9cf Add TS to output. Don't require initial n and t. 2011-09-22 09:04:11 -06:00
Daniel Nichter
43ecc8546d Replace ReplicaLagLimiter with ReplicaLagWaiter and WeightedAvgRate. Don't inherit rate from prev tables. Store nibble_time and chunk_size in $tbl. 2011-09-21 11:31:36 -06:00
Daniel Nichter
f6fb8b44bd Decompose ReplicaLagLimiter into ReplicaLagWaiter and WeightedAvgRate. Don't use OptionParser in NibbleIterator; use chunk_size arg instead. 2011-09-21 11:19:49 -06:00
Daniel Nichter
31d6171355 Restore --max-lag and friends. 2011-09-21 10:39:55 -06:00
Daniel Nichter
d979821efe Rewrite ReplicaLagLimiter::wait(). 2011-09-21 10:30:33 -06:00
Daniel Nichter
6784bf30c3 Make error message prettier. 2011-09-20 12:00:42 -06:00
Daniel Nichter
bfb5b7ae6a Implement ReplicaLagLimiter. Add --chunk-time. 2011-09-20 11:52:35 -06:00
Daniel Nichter
006b93ddf9 Create ReplicaLagLimiter. Replace --max-lag, --check-interval, and --check-slave-lag with --replica-lag and --replica-lag-dsn. Use TableParser::get_table_status() in NibbleItertor. Eval SHOW TABLE STATUS. Auto-add "n" (name) part to parsed DSNs. 2011-09-16 17:35:40 -06:00
Daniel Nichter
32ade00663 Eval entire checksum op for each tbl. Use "percona" as default db for checksums table. 2011-09-15 11:46:57 -06:00
Daniel Nichter
bc2401ebf5 Remove MySQLDump from pt-table-checksum. Use "$tp" instead of "$du" in SchemaIterator. 2011-09-15 09:41:47 -06:00
Daniel Nichter
d5eb621333 Set AutoCommit=1. 2011-09-14 10:57:06 -06:00
Daniel Nichter
2f2644caf1 Update RowChecksum and OptionParser in pt-table-checksum. 2011-09-14 10:41:37 -06:00
Daniel Nichter
d881fa0b35 Change --chunk-size to type size. Make TIME column %.3f. Make OptionParser report invalid sizes. 2011-09-14 10:40:42 -06:00