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
>
>
>
>
>
> Nilnandan wrote:
>>
>> 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@...
>>>
>>>
>>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/Frequently-MyISAM-TABLE-corruption.....Pls-help-tf3715472.html#a11391620
> Sent from the MySQL - General mailing list archive at Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=mysqlsupport@...
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.476 / Virus Database: 269.9.14/883 - Release Date: 7/1/2007
> 12:19 PM
>
>