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 lock
kind of Ueber-Beast-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 trou
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 64
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 m
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
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
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
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 MySQ
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 smooth (as always).
>
> Then I enabled for the first
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
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
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 (
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 t
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 to
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 a
"Kissandrakis S. George" wrote :
>
> Hello
>
> I have mysql 3.23.31 on x86 linux
> Some big tables .ISM get corrupted without any crash or shutdown of
> mysqld
> Any suggestions?
>
> --
> Kissandrakis S. George [[EMAIL PROTECTED]]
> Network and System Administrator [http:/
Hello
I have mysql 3.23.31 on x86 linux
Some big tables .ISM get corrupted without any crash or shutdown of
mysqld
Any suggestions?
--
Kissandrakis S. George [[EMAIL PROTECTED]]
Network and System Administrator [http://www.phaistosnetworks.gr/]
Tel/Fax: (+30 892) 24450/23
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 mysq
18 matches
Mail list logo
