Hi,
Pls try altering the engine type from 'MyISAM' to 'InnoDB'
mysql > alter table `tablename` ENGINE='InnoDB';
Just try out. I'm not sure. But there are issues over 'MyISAM' engine' and
table corruption. Pls look into the link
http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html about
mysqleers comments.
Thanks
ViSolve DB Team.
----- Original Message -----
From: "Nilnandan" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, July 02, 2007 3:58 PM
Subject: 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/[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]
--
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
