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 o
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
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
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 s
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
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 ba
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, y
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)
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
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 repa
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/manua
> when you run myisamchk it try to find the .MYI file.
> If you try to run myisamchk on the MYD file, it says that the key definition
> is incorrect (which seems to be normal ;))
The key definition should be part of the .frm file, in my
understanding. Oh, I see, myisamchk is invoked on
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
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 ?
BTW, REPAIR TABLE in mysql report a wrong message :
mysql> REPAIR TABLE threadhar
39 PM
> To: [EMAIL 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 dete
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_reads versus Key_read_requests. Key_reads divided by
Key_read_requests would
Hi all,
Would be real grateful for some help on speeding up selects on a large table
(20+ million rows).
My question is: Is it possible to load just the index MYI file into RAM and
if this is possible, will this improve performance on selects?
Thank you for any help.
Michael Thomas
18 matches
Mail list logo
