From: Johan De Meersman Date: December 6 2010 10:40am Subject: Re: Loading date takes a long time after replication List-Archive: http://lists.mysql.com/mysql/223738 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00032555820223f34c0496bb83fc --00032555820223f34c0496bb83fc Content-Type: text/plain; charset=ISO-8859-1 Are you saying that mass inserts go much slower now that you've set up replication? In that case, I suspect you have your binlogs on the same disk as your data. Put the binary logs on separate disks, and you'll notice a dramatic increase in performance. On Mon, Dec 6, 2010 at 7:17 AM, Sairam Krishnamurthy wrote: > 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. > > Is there a workaround for this? We really don't want to wait for hours for > the table to be loaded. Should we abandon replication for this? Any pointers > ? > > -- > Thanks, > Sairam Krishnamurthy > +1 612 859 8161 > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --00032555820223f34c0496bb83fc--