problem related to MyISAM table
Hello Everybody,
I need an urgent help on this. This problem occurs once in a month. our storage engine is MyISAM. we have a table called fitch_ratings_master which includes currently 1361 records and records are increasing.
Problem is records has often gets deleted from this table. we have many tables in the same database, but only this table is having deletion problem.
table doesn't get corrupted, but records gets deleted.
following is the status of the table.
+----------------------+--------+------------+------+----------------+----------
---+-----------------+--------------+-----------+----------------+--------------
-------+---------------------+------------+----------------+---------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_leng
th | Max_data_length | Index_length | Data_free | Auto_increment | Create_time
| Update_time | Check_time | Create_options | Comment |
+----------------------+--------+------------+------+----------------+----------
---+-----------------+--------------+-----------+----------------+--------------
-------+---------------------+------------+----------------+---------+
| fitch_ratings_master | MyISAM | Dynamic | 1361 | 60 | 824
04 | 4294967295 | 1024 | 0 | NULL | 2005-04-06 15
:23:47 | 2005-04-06 17:06:18 | NULL | | |
+----------------------+--------+------------+------+----------------+----------
---+-----------------+--------------+-----------+----------------+--------------
-------+---------------------+------------+----------------+---------+
please help me out. thanks in advance.
regards,
sakshi
Subject
Views
Written By
Posted
problem related to MyISAM table
3522
April 07, 2005 12:11AM
2364
April 07, 2005 01:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.