Have a look at your /var/log/messages for messages around the time the
table crashes . It really should not crash this much. Is there a
quota system on your box ? I once had a table marked corrupt and
though I tried hard to find where the problem is, I was not able to.
Eventually, it turne
matt_lists wrote:
every few days I get one of these
MySql: Can't open file: 'mrf.MYI' (errno: 145)
For more information, see Help and Support Center at
http://www.mysql.com.
Checking table: './db/mrf'
For more information, see Help and Support Center at
http://www.mysql.com.
Recovering table: '
matt_lists wrote:
Raj Shekhar wrote:
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext
index on it. The table gets corrupted every 1 week or so and I have
to repair it. I've tried upgrading to newer versions of mysql 3
times but the problem persists. I t
Raj Shekhar wrote:
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext
index on it. The table gets corrupted every 1 week or so and I have
to repair it. I've tried upgrading to newer versions of mysql 3 times
but the problem persists. I think it may have s
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have something to do with
Random hardware failures will NOT only impact a single file.
The only thing that I know that will consistantly fail at the same spot is s/w.
On Mon, 03 Jan 2005 16:32:31 -0800, Mark Maggelet
<[EMAIL PROTECTED]> wrote:
> Thanks Mike,
> It's hardware raid, but I don't know the manufacturer. I could
Thanks Mike,
It's hardware raid, but I don't know the manufacturer. I could try to
find out but if the problem is the hardware there isn't much I can do
about it anyway without turning it into a big project.
I'm not really expecting to solve this, I'm just hoping for some advice
on what the pro
At 12:37 PM 1/3/2005, you wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have somethin
keywords`)
) TYPE=MyISAM
OS is RedHat 9 - 2.4.20-8smp
I'd rather not upload the crashed table because it is really big and it
has some sensitive data.
Thanks,
- Mark
Heikki Tuuri wrote:
Mark,
- Original Message - From: "Mark Maggelet"
<[EMAIL PROTECTED]>
Newsgroups: mailing.datab
Mark,
- Original Message -
From: "Mark Maggelet" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, January 03, 2005 8:36 PM
Subject: big table corruption
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The tabl
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have something to do with the raid 1
mirror b
11 matches
Mail list logo
