Dear All,
We are using mysql ver 4.0.17 on lunux with external SCSI media for db storage.
We are using innodb engine and we experience that the db processes still
services some transactions even when the scsi media on which db resides is
physically disconnected.
Would anybody throw lig
Andy,
Thanks a lot for the response. We are using Linux OS. Is there any
configuration parameter that enables more frequent flush or a parameter
that enables direct write to disk and any idea about performance
implications.
Thanks once again,
Ravi
-Original Message-
From: andy thoma
Dear all,
We are running mysql 4.0.17 on linux environment. Our database resides
on external disk connected via FC cables. We recently noticed a loss
of data in the following scenario.
Inserted a row in a table in a separate transaction by a java
application,
queried a row in the table in a s
Hi Friends:
We are using mysql version 4.0.17 on Linux with a master and a single
slave both running on the same node.
We have encountered a problem in replication in the following scenario:
First the slave got abnormally terminated while there were some active
connections to the master.
The m
Charles,
Sometimes, the connection to disk array will not be available to this
server for long time and in such a case, we want another server to
connect to the disk array and run mysql processes. Unfortunately, from
our design, this cannot happen until the existing server shuts down.
I am hap
Hello:
We are using mysql 4.0.17 on Linux
We have installed a mysql database on our our server. The data and log
files are stored on an external SCSI disk array which is connected to
our server using FC cable connected to SCSI port. The mysql process is
running on the local machine but the dat
Friends,
Sorry to post this question again. I got a message saying that the server couldn't
transfer this message to some groups. Also I didn't get any response to this
question.
We are using mysql 4.0.17 with innodb option. In a query, when a WHERE clause
contains a non-indexed colu
Hi Friends,
We are using mysql 4.0.17 with innodb option. In a query, when a WHERE clause
contains a non-indexed columns, it locks the entire table instead of row lock. Is
there any solution apart from building index on each query key ? Is there a solution
in any of the later versions ?