enterprise-support team mailing list archive

[Andreas Piesk <1262706@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

this is not a bug, more an enhancement idea and it's not fully tested

i have some big partitioned tables without any indexes useable by the
chunk logic (indexed field is non-numeric).

The patch is rather large, so handle with care.

i had to change the server detection code because SELECT FROM TABLE
PARTITION(X) is available in 5.6.2+ only and detect_server() doesn't
fetch the version number.

Maybe the use of partitions vs. indexes should be controlled by some
options but i think, if a table is partitioned, mydumper should use
partitions as chunks.

** Affects: mydumper
     Importance: Undecided
         Status: New

** Patch added: "add partitions as first option in chunk logic"
   https://bugs.launchpad.net/bugs/1262706/+attachment/3932606/+files/mydumper-0.5.2-partitionchunks.patch

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1262706

Title:
  use partition as chunks

To manage notifications about this bug go to:
https://bugs.launchpad.net/mydumper/+bug/1262706/+subscriptions