On Fri, Nov 07, 2003 at 09:16:03AM -0800, Eric Anderson wrote:
>
> A little explaination:
[snip]
> The threads connecting from the 1U (192.168.0.2) all start to block up
> as expected, but when the length query on the e450 stops running, the
> threads from the 1U stay blocked, and all NEW thread
> Is anything being logged in the error log?
Nope.
My 'wait_timeout' was set to 120 seconds, I reduced that down to 60
seconds but I don't think that will help because once it gets "stuck" in
this blocked thread thing, it never recovers.. any subsequent
connections never actually process, until t
Is anything being logged in the error log?
-Original Message-
From: Eric Anderson [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:16 AM
To: [EMAIL PROTECTED]
Subject: Very strange problem
A little explaination:
We've got two servers, e450 (3.23.47) and 1U (4.0.14).
A little explaination:
We've got two servers, e450 (3.23.47) and 1U (4.0.14). These two
machines have a private connection between them (192.168.0.1 and
192.168.0.2).
The e450 is the master server, and the 1U has a copy (no replication)
of some basic data, so it can run server-intensive pages.
Hi,
I do commit alright. This doesn't happen often. i insert into the tables
from a java web app. The db and the data in it is fine when i stop and
restart the web server(tomcat). sometimes when i restart the machine,
data is all intact.
I was using the mysql 4 max before. Same thing happene
On Fri, May 03, 2002 at 11:04:29AM +0530, TP R Murthy wrote:
>
> I have created only one database with 18 tables. Only one of these tables
> is MyIsam table. rest are BDB tables. When the server is up, it works
> fine. but when i reboot the machine, few of the tables loose all the
> records th
Hi,
I am new to this list. i could find solution to this problem on the net.
i have a RH7.1 512Mb single intel processor. I have installed
mysql-3.23.49a-max (binary). I have included the mysql.server script in
the init dir and created links to it in rc6, rc5,rc3 and rc1 dir.
I have create