Hello everyone,

I have a mysql table full. Any idea on how to change the max datafile size or anything that could allow me to fix this urgent problem?

Thanks,
Emilio

-


Datafile length: 4294967256 Keyfile length: 1958912
Max datafile length: 4294967294 Max keyfile length: 4398046510079
Recordlength: 76

Re-design your database stucture by creating multiple tables (with foreign, primary, and concatnatent keys) - like intersection tables.

This will reduce the risk of maxing out your individual table allowance.

bye...

Regards,

Eliot Lee

MMhh... is there anything I could do with this table?

Ask your hosting company to bump up your table limit.

Other than that, you will have re-design your data structure...

Regards,

Eliot Lee

How can I bump up the table limit? I'm on a dedicated server, so I guess I could do that myself (but I don't know how)

http://www.mysql.com

search for table limits.

Regards,

Eliot Lee

No, the MySQL table full error is usually not related to your table size (which is limited to max size of a file on a hard drive, typically 2 gigs on a linux system).

Table full means mysql could not generate a temp table of sufficent size for doing an order by query. Try passing:

SET OPTION SQL_BIG_TABLES = 1

just before your query. Also, you may look at where mysql is using for temp tables (particularly if this is a windows system) and make sure there is adequate room.

Cheers,

Alex

--
Gossamer Threads Inc.

Hi Alex,

I'm planning on using the --with-raid option. Have you tried it? ANy comments?

Thanks,
Emilio

Hi,

One issue shouldn't be related to the other. I haven't tried MySQL with raid though, so I can't comment on it unfortunately. =)

Cheers,

Alex

--
Gossamer Threads Inc.

Hi,

Well, I will try it and let you know :)

Cheers,
Emilio

I used the --with-raid option, and the datafile is now split in 4 differente files. However, I still get the following:

myisamchk: warning: Datafile is almost full, 4294967292 of 4294967294 used

Do you know of any way to increase that size?