error 135

2009-08-10 Thread Ron
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

Re: error 135

2009-08-10 Thread Carlos Proal
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):

Re: error 135

2009-08-10 Thread Ron
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