Re: Frequently MyISAM TABLE corruption.....Pls help

hello

I am still facing the same problem..
MyISAM table corruption....I am getting following errors

mysql> use DB1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> check table tables1;

+----------------------+-------+----------+---------------------------------+
| Table                | Op    | Msg_type | Msg_text                        |
+----------------------+-------+----------+---------------------------------+
| DB1.tables1 | check | error    | Found wrong record at 967175516 |
| DB1.tables1 | check | error    | Corrupt                         |
+----------------------+-------+----------+---------------------------------+

2 rows in set (8.53 sec)

==================================================================================================
ERROR LOG
==========================================================================

Version: '5.0.27-standard-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)

070702  1:16:18 [ERROR] /usr/sbin/mysqld: Table 'tables1' is marked as crashed and should be repaired
070702  1:16:18 [ERROR] /usr/sbin/mysqld: Sort aborted
070702  1:19:43 [ERROR] Got error 127 when reading table './DB1/tables1'
070702  1:19:54 [ERROR] Got error 127 when reading table './DB1/tables1'
070702  1:20:05 [ERROR] Got error 127 when reading table './DB1/tables1'
070702  1:20:22 [ERROR] Got error 127 when reading table './DB1/tables1'
070702  1:21:24 [ERROR] Got error 127 when reading table './DB1/tables1'
070702  1:22:16 [ERROR] Got error 127 when reading table './DB1/tables1'
070702  1:22:17 [ERROR] /usr/sbin/mysqld: Table 'tables1' is marked as crashed and should be repaired
070702  1:22:17 [ERROR] /usr/sbin/mysqld: Sort aborted

 
Database changed

mysql> repair table tables1;

+----------------------+--------+----------+---------------------------------------------------------+
| Table                | Op     | Msg_type | Msg_text                                                |
+----------------------+--------+----------+---------------------------------------------------------+
| DB1.tables1 | repair | info     | Key 1 - Found wrong stored record at 967175516          |
| DB1.tables1 | repair | info     | Found block that points outside data file at 967175964  |
| DB1.tables1 | repair | info     | Found block that points outside data file at 967176068  |
| DB1.tables1 | repair | info     | Found block that points outside data file at 967176168  |
| DB1.tables1 | repair | info     | Found block that points outside data file at 967176296  |
| DB1.tables1 | repair | info     | Found block that points outside data file at 967176484  |
| DB1.tables1 | repair | info     | Found block that points outside data file at 967176588  |
| DB1.tables1 | repair | info     | Found block with too small length at 967177484; Skipped |
| DB1.tables1 | repair | warning  | Number of rows changed from 186252 to 186251            |
| DB1.tables1 | repair | status   | OK                                                      |
+----------------------+--------+----------+---------------------------------------------------------+
10 rows in set (1 min 27.77 sec)


PLS help me ASAP..........Its frequently corrupted..It is very important table

Regards,

Nilnandan Joshi
DBA-INDIA





Hello Gerald,

Data_length    Max_data_length         Index_length
596483288    281474976710655         33758208  

580 MB is table size and 32MB is index size.....
The default maximum MyISAM size is 4GB.

Now, tell me where is an issue....?

regards,
Nilnandan Joshi
DBA-SDU
Juriscape

Gerald L. Clark-2 wrote:

Nilnandan wrote:
> Hello all,
>
> I have one server which has mysql 5.0.27 installed. There is one table named
> table1.
> that table has 122000 records..It has 114 fields and 22 indexes.
>
> Now this table always been corrupt. I have try to found the solution but i
> couldn't.
> Pls help me ASAP. I have used CHECK and REPAIR option I have given here the
> output.....
>
> 070509  4:06:17 [ERROR] /usr/sbin/mysqld: Table 'table1' is marked as
> crashed and should be repaired
> 070509  4:06:17 [ERROR] /usr/sbin/mysqld: Sort aborted
> >
How big is the index file? the data file?
Has either reached the file size limit of your filesystem,
or the default maximum MyISAM size?


--
Gerald L. Clark
Supplier Systems Corporation

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=lists@nabble.com