What is the output of "show full processlist" On Mon, Jan 3, 2011 at 1:10 PM, Sairam Krishnamurthy <kmsram...@gmail.com>wrote:
> Hi all, > > I set up replication some days back. Because of some internal issues we > canceled the replication and reset the master to be a normal database > server. But after this "revert", the database is unusually slow. > > It was slow because of the discussion below when replication was on. But I > wonder why it is slow now after the master has been reset. By reset I mean, > commenting out the master setup lines in the my.cnf file, removal of logs > and restarting the database. > > Thanks in advance > > > Thanks, > Sairam Krishnamurthy > +1 612 859 8161 > > > On 12/06/2010 04:47 AM, Ananda Kumar wrote: > >> 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 <vegiv...@tuxera.be<mailto: >> vegiv...@tuxera.be>> 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 >> <kmsram...@gmail.com <mailto:kmsram...@gmail.com>>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 >> >> >>
