Hello ,
Few time ago I've started to get the following problems, which several
times allready lead to data lost for me.
Here is the example:
I found the followings in my application error log:
Query - #1017 [opal.local] - Can't find file: 'g04stat_languages.MYD' (errno: 2)
select visitors,loads,id ,hits from layers_st45.g04stat_languages where layer_id=19573
05.Apr 16:30:28 : pid:5224 h -- 65972/0 AllInOne rec:0 l:0 tm:1627.20 #
05.Apr 16:30:28 : pid:5224 h 65972/0 [03.23 17:10] - [01.01 02:59] q:3.73 i:0.00
a:3.26 #
So If I check mysql it's running quite well and long:
opal:/spylog/layers # mysqladmin status
Uptime: 255087 Threads: 74 Questions: 28129440 Slow queries: 1453 Opens: 225540
Flush tables: 1 Open tables: 1024 Queries per second avg: 110.274
opal:/spylog/layers #
The logfile contains NO errors or snything about this
I went to look what is wrong with the file: The problem is index file
is gone. And there are MUCH such situations - I get several files lost
each day.
opal:/spylog/db/layers_st45 # ls -la g04stat_lang*
-rw------- 1 mysql daemon 1473241 Mar 26 18:54 g04stat_languages.MYD
-rw------- 1 mysql daemon 8664 Jan 12 19:09 g04stat_languages.frm
This is not the worst case - in several tables I had .MYD file to be
not existant, but TMD file left - so I just rename it and it works
find. One or two times I didn't find even TMD file so I had to look
at my backups.
Looking at the table I found They are usually distributed in one table
group - for example I get many from layers_stXX.gXX* lost there no
over tables lost, so I think this is related to my purge program (this
is still mysql bug anyway :)) ). The thing is after deleting some data
from table the program uses REPAIR table - this is from the times
then optimize table was several times slower.
I'm using mysql 3.23.36, and nothing is changed in system, only mysql,
also I had this problem with mysql 3.23.32 if I'm not mistaken.
I'll try to make an repeatable example but I'm not shure I'll be able
to do so as this does not happens to all tables this program work with
- this may happen only in some specific cases - may be then other
program is working with the table or something.
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
