Hi,

Is this the same for ndbcluster engine?

"Note that error 135 (no more room in record file) and error 136 (no more room in index file) are not errors that can be fixed by a simple repair. In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values:

ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy

but, currently i dont have the table yet, i'm just trying to create a new table and i get that message? any clue? TIA.

Regards
Ron



Carlos Proal wrote:
This might help
http://dev.mysql.com/doc/refman/5.0/en/repair.html

Carlos

On 8/10/2009 11:51 PM, Ron wrote:
Hi All,

why do i have this error. i have recently setup a mysql cluster, i now have around 60 tables on it. when i create a new one, it gives me this error.

ERROR 1005 (HY000): Can't create table './mydb/#sql-3e87_24c9a5d.frm' (errno: 135)


any idea? TIA!

Regards
Ron




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

Reply via email to