Re: Loading date takes a long time after replication

Any pointers on this issue ? Thanks, Sairam Krishnamurthy +1 612 859 8161 On 01/03/2011 01:51 AM, Ananda Kumar wrote: What is the output of show full processlist On Mon, Jan 3, 2011 at 1:10 PM, Sairam Krishnamurthy kmsram...@gmail.com mailto:kmsram...@gmail.com wrote: Hi all, I

Re: Loading date takes a long time after replication

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

Re: Loading date takes a long time after replication

What is the output of show full processlist On Mon, Jan 3, 2011 at 1:10 PM, Sairam Krishnamurthy kmsram...@gmail.comwrote: 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

Re: Loading date takes a long time after replication

Apparently nothing. Just the Show process list query. 70100 | user | localhost | database | Query |0 | NULL | show full processlist Thanks, Sairam Krishnamurthy +1 612 859 8161 On 01/03/2011 01:51 AM, Ananda Kumar wrote: What is the output of show full processlist On Mon, Jan 3,

Re: Loading date takes a long time after replication

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

Re: Loading date takes a long time after replication

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.bewrote: Are you saying that mass inserts go much

Re: Loading date takes a long time after replication

Thanks Guys. Let me check these options and will get back with the results. Thanks again. 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

Re: Loading date takes a long time after replication

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

Loading date takes a long time after replication

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

Re: After replication

On Fri, May 11, 2001 at 01:23:00PM +0300, Kissandrakis S. George wrote: i installed replication between two mysql servers Now what? Relax. Have a drink. Read a book. :-) is there any software which does insert,deletes,updates on the master and select on both machines or on slave('s)

After replication

Hello i installed replication between two mysql servers Now what? is there any software which does insert,deletes,updates on the master and select on both machines or on slave('s) only? is there any recommended setup (virtual ips, NAT anything) that will do the above? -- Kissandrakis S.