--flush option and fsynch option for innodb engine

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

RE: Data loss problem with mysql

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

Data loss problem with mysql

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

replication problem

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

mysqladmin shutdown command hangs

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

RE: mysqladmin shutdown command hangs

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

mySQL: Table locking problems when non-index keys used

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

mySQL: Table locking problems when non-index keys used

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 ?