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/[EMAIL PROTECTED]
>>
>>
>>
>
>
--
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/[EMAIL PROTECTED]
