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
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
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
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
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
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 table gets corrupted every 1
: 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 table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3
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
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
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
11 matches
Mail list logo