From: Ananda Kumar Date: December 6 2010 10:47am Subject: Re: Loading date takes a long time after replication List-Archive: http://lists.mysql.com/mysql/223739 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00163683394aa0b5210496bb9c22 --00163683394aa0b5210496bb9c22 Content-Type: text/plain; charset=ISO-8859-1 Also, make sure your /tmp folder is on a separate and fast disk. We had similar issues and we moved /tmp folder from Local to SAN storage and it was quite fast. regards anandkl On Mon, Dec 6, 2010 at 4:10 PM, Johan De Meersman wrote: > 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 > --00163683394aa0b5210496bb9c22--