Re: Very long pauses on particular tables

2006-08-16 Thread Chris
Daniel Kasak wrote: Chris wrote: Could be a simple network issue too.. are pings fast/slow? Pings are very fast. The reason I asked about that last one was some of the suggestions on this page: http://www.debuntu.org/2006/07/21/75-how-to-optimize-mysql-response-time/ OK. I've had a read

Re: Very long pauses on particular tables

2006-08-16 Thread Daniel Kasak
Chris wrote: > Could be a simple network issue too.. are pings fast/slow? Pings are very fast. > The reason I asked about that last one was some of the suggestions on > this page: > > http://www.debuntu.org/2006/07/21/75-how-to-optimize-mysql-response-time/ OK. I've had a read of that, and it s

Re: Very long pauses on particular tables

2006-08-16 Thread Chris
Daniel Kasak wrote: Chris wrote: I'd see if you can get logging enabled. I will do that next visit, yes. I was pushed for time - in between 2 other commitments, and wasn't expecting problems. When the pauses happen try a 'show process list;' and see what else mysql is doing at the time. May

Re: Very long pauses on particular tables

2006-08-16 Thread Daniel Kasak
Chris wrote: > I'd see if you can get logging enabled. I will do that next visit, yes. I was pushed for time - in between 2 other commitments, and wasn't expecting problems. > When the pauses happen try a 'show process list;' and see what else > mysql is doing at the time. Maybe you have a deadl

Re: Very long pauses on particular tables

2006-08-16 Thread Chris
Daniel Kasak wrote: Hi all. I discovered a very strange and painful problem on a customer's system last night. I have built a gtk2-perl GUI front-end for accessing data in a MySQL database. It works remarkably well on my laptop, and was working remarkably well on their system as well, but somet

Very long pauses on particular tables

2006-08-16 Thread Daniel Kasak
Hi all. I discovered a very strange and painful problem on a customer's system last night. I have built a gtk2-perl GUI front-end for accessing data in a MySQL database. It works remarkably well on my laptop, and was working remarkably well on their system as well, but something has recently happ