Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #903506
  2. Comment #5

Comment 5 for bug 903506

Revision history for this message
Hui Liu (hickey) wrote :

There exists two issues:
1. no pk but exists index => no index would be used
it's solved by finding suitable index, ref https://kb.askmonty.org/en/row-based-replication-with-no-primary-key/

2. no pk and index => each table is needed for SQL that effects many rows.
it's solved by hash scan used in 5.6, ref http://binlogtorelaylog.blogspot.in/2012/08/Batch-operations-in-RBR.html