In infinite wisdom Sairam Krishnamurthy <kmsram420@stripped> wrote:
> [1 <text/plain; ISO-8859-1 (7bit)>]
> I have a situation. We have a very large database(gigabytes). When we
> load the data in to the table, it will be huge again (20 million rows).
> So in order to get good backup we set up a replication(master-slave
> setup). But now, because of this setup, loading into the table takes
> hours which will be generally done in a few minutes otherwise.
What part of the system is busy the most when you load the data - is it
the CPU or the disk or the network? Replication should not slow down
the speed of the insert, this might just be a red herring and the
problem might be somewhere else.
If there's anything more important than my ego around, I want it
caught and shot now.
Read the latest at my blog: "Humor in the bookstore"