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=gcdmg-mysql-2@m.gmane.org
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=gcdmg-mysql-2@m.gmane.org
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=gcdmg-mysql-2@m.gmane.org