In infinite wisdom Sairam Krishnamurthy <kmsram...@gmail.com> wrote: > [1 <text/plain; ISO-8859-1 (7bit)>] > All, > > 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. -- Raj Shekhar - 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" <http://rajshekhar.net/blog/archives/391-Humor-in-the-bookstore.html> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
