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
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
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
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,
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
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
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
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
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