Hi Gerald, Michael,
Gerald L. Clark wrote:
Never put MySQl data files on an NFS exported share.
Michael Dykman wrote:
This is a bit of a generalization, but file locks are known to be
pretty flakey and unreliable under NFS.. any kind of serious load
begs races conditions which file locks
-Killer-Maschine.
All servers running in Vmware don't contain virtual Vmware hard discs but have
NFS mounted root and data, etc. partitions.
We're very often, daily!, getting spontaneous corrupted tables on the server
with the version which gets us really in trouble.
The only pattern so far
On Tuesday 15 May 2007 14:36:45 Mathieu Bruneau wrote:
Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note
thta some memory is allocated for the OS so you don't even have the full
4GB of ram you can technically adressesed.
The 64 bits os would increase this limit to 64gb++
How about your disk space? I had a similar problem on a large table and
it ended up being caused by filling up the disk.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Octavian Rasnita wrote:
From: Steve Edberg [EMAIL PROTECTED]
Sometimes I see that some tables from my
Hi,
Sometimes I see that some tables from my database get corrupted. Why does
this happpen and how can I avoid it?
It is not hard to go and use repair table but it seems that in this way
some records could be deleted and this is not ok.
If I want to have a very secure database, can I use
Octavian Rasnita wrote:
Hi,
Sometimes I see that some tables from my database get corrupted. Why
does this happpen and how can I avoid it?
It is not hard to go and use repair table but it seems that in this
way some records could be deleted and this is not ok.
If I want to have a very secure
At 6:56 PM +0200 3/16/07, Octavian Rasnita wrote:
Hi,
Sometimes I see that some tables from my database get corrupted. Why
does this happpen and how can I avoid it?
It is not hard to go and use repair table but it seems that in
this way some records could be deleted and this is not ok.
If I
From: Steve Edberg [EMAIL PROTECTED]
Sometimes I see that some tables from my database get corrupted. Why does
this happpen and how can I avoid it?
It is not hard to go and use repair table but it seems that in this way
some records could be deleted and this is not ok.
If I want to have a very
: mailing.database.mysql
Sent: Saturday, October 12, 2002 2:02 AM
Subject: Mysql 4.0.4 + InnoDB leads to corrupted tables ?
Hi,
I recently updated from 4.0.3 do 4.0.4 .
everithing was running fast ans smooth (as always).
Then I enabled for the first time the InnoDB feature.
I was surprised to find out
Andrea,
- Original Message -
From: Andrea Forghieri [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, October 12, 2002 2:02 AM
Subject: Mysql 4.0.4 + InnoDB leads to corrupted tables ?
Hi,
I recently updated from 4.0.3 do 4.0.4 .
everithing was running fast ans
Hi,
I recently updated from 4.0.3 do 4.0.4 .
everithing was running fast ans smooth (as always).
Then I enabled for the first time the InnoDB feature.
I was surprised to find out that everithing worked fine
from the very beginning.
The next day I start having handler error on non-inno tables
Hello,
We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and
we are constaly facing problems with corrupted tables, especially on two of our
busiest servers.
Tables seem to corrupt out of the blue and we have to shut them down ( the servers )
occassionaly
On Fri, Sep 07, 2001 at 10:29:31AM +0300, Mark Papadakis wrote:
Hello,
We are using mySQL on over 6 servers here, we have been doing so for
over 2 years, and we are constaly facing problems with corrupted
tables, especially on two of our busiest servers. Tables seem to
corrupt out
Mark Papadakis wrote:
We are using mySQL on over 6 servers here, we have been doing so for over 2 years,
and we are constaly facing problems with corrupted tables, especially on two of our
busiest servers.
Tables seem to corrupt out of the blue and we have to shut them down ( the servers
I've had some db corruption on a few occasions, and luckily I was running the
following in a nightly cron...it has since first install saved my butt on
many an occasion. http://www.ocsny.com/main/index.ocs?url=mysqlbackup It
doesn't do anything magickal just uses mysqldump and a basic routine to
Hi!
No, I can't repeat it on command, sorry.
However, I can give a little more info. When inserting, the index file got
bigger. It was the data file that was set to 0 bytes, but did not get bigger
on inserts. Doing a repair fixed it.
I have some tables truncated via scripts, so I turned on
16 matches
Mail list logo