There are too many reasons for that. Yes, users who press reset button, power
outage,
buggy hardward or OS, even corrupted MySQL builds may cause this to happen.
Example: we often have this kind of troubles on FreeBSD 5.x on high load with big
databases
(tens of gigs). This happens because of
Hello,
We had a situation over night where users were getting the error message:
[My SQL][ODBC 3.51 Driver][mysqld-4.0.13-nt] Can't open file: flex. MYI:
[error : 145]
I found that .MYI file had become corrupted and I repaired the table and
things are working as they should now.
However
Eric Lommatsch wrote:
Hello,
We had a situation over night where users were getting the error message:
[My SQL][ODBC 3.51 Driver][mysqld-4.0.13-nt] Can't open file: flex. MYI:
[error : 145]
I found that .MYI file had become corrupted and I repaired the table and
things are working as they should
Hello,
I have had some Error 127 on my system so I ran myisamchk -rf when mysqld was down.
Now I noticed my .MYI file is at 1024K:
-rw-rw1 mysqlmysql1024 Nov 11 16:33 table.MYI
My .MYD, .frm are still there:
-rw-rw1 mysqlmysql8802 Nov 6 07:04 table.frm
Hi All,
I tarred up the data directory from mirror1 data base - slave. Copied the
tarball to mirror2 with the hopes of rebuilding mirror2 - another slave.
Backed up the data directory from mirror2 into old and untarred mirror1
Then I did a diff -r against another mirror and the diff came
To be a bit clearer,
should the MYI index files betweened two slaves of a mirrored database be
different?
I would think they would be identical, right?
Thanks
-Original Message-
From: DePhillips, Michael P
To: [EMAIL PROTECTED]
Sent: 7/16/2003 6:18 PM
Subject: MYI file difference
Hi
In the last episode (Jul 16), DePhillips, Michael P said:
To be a bit clearer,
should the MYI index files betweened two slaves of a mirrored
database be different?
I would think they would be identical, right?
If both master and slave are set up identically, then theoretically
they should
Hello list,
Can I use myisamchk to check the index without shutdown the mysql server?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
In the last episode (Oct 08), Patrick Hsieh said:
Hello list,
Can I use myisamchk to check the index without shutdown the mysql
server?
As long as your mysqld is running with locking enabled. You can check
by running SHOW VARIABLES LIKE 'skip_external_locking' . If it's
set to NO, you
Are the MySQL MYD/MYI file formats documented anywhere? Are they any
utilities that will dump these out for debug purposes?
-Rolf
--
Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK.
-
Before posting, please check
I lost the .MYI file, I still have the FRM and MYD files.
There's any way to recover this table? Recreating the index file?
thanks
Thiago Lima.
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi!
On Sep 24, Thiago Madeira de Lima wrote:
I lost the .MYI file, I still have the FRM and MYD files.
There's any way to recover this table? Recreating the index file?
Sure.
See http://www.mysql.com/doc/R/e/Repair.html (Stage 3: Difficult repair)
Regards,
Sergei
--
MySQL
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote:
Hi,
I'm administrating a machine which has just badly crashed, and a MYI
file has disappeared for one table. Is this possible to repair this
table?
Try to touch the file (to create an empty one), and see
PROTECTED]
Subject: Possible to load only index MYI file into RAM?
You can tell MySQL to use (lots) more RAM to cache
Index Keys by setting
an explicit value for its key_buffer variable. You can use the
SHOW STATUS query to determine the cache hit rate by
comparing these
two values: Key_
14 matches
Mail list logo
