MySQL Forums
Forum List  »  MyISAM

problem related to MyISAM table
Posted by: sakshi kachare
Date: April 07, 2005 12:11AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
problem related to MyISAM table
3384
April 07, 2005 12: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.