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.
On Mon, Dec 6, 2010 at 4:10 PM, Johan De Meersman <vegivamp@stripped>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
> in performance.
> On Mon, Dec 6, 2010 at 7:17 AM, Sairam Krishnamurthy <kmsram420@stripped
> > All,
> > I have a situation. We have a very large database(gigabytes). When we
> > 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
> > generally done in a few minutes otherwise.
> > Is there a workaround for this? We really don't want to wait for hours
> > the table to be loaded. Should we abandon replication for this? Any
> > ?
> > --
> > 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