enterprise-support team mailing list archive

[Scott Wheeler <wheeler@xxxxxxx>]

Public bug reported:

I noticed that per chance my largest table in a database I'm testing
with was being loaded last with myloader, which meant that it spent most
of its loading time not benefiting from parallelism.

I added a bit of code to sort the table list by decreasing file size,
which ensures that the larger tables are loaded first.  (File size isn't
a perfect proxy for load time, but it's much better than random.)

Patch attached.

** Affects: mydumper
     Importance: Undecided
         Status: New

** Patch added: "myloader-load-large-tables-first.patch"
   https://bugs.launchpad.net/bugs/1579479/+attachment/4658521/+files/myloader-load-large-tables-first.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/1579479

Title:
  Tables are loaded in a random order, loading large ones first is
  preferable

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