How to overcome the 4G file size limit on fat32 by file splitting?

[onlyra]

Hy!
I have a program that uses mysql(version 3 or 4) for storing a database with the legislation from my country ans the .MYD table data has reached the 4Giga size limit. I used Jeremy Zawodny’s alter table advice (

http://jeremy.zawodny.com/blog/archives/000796.html

) and now with NTFS my database can be biger than 4 Giga. What can I do with the database fot those clients that have a Fat32 file system?

So my qestion is: Is there a way to convince mysql split somehow (ideally... automatically) the .myd table data in files smaller than 4G without making major adjustments to my program?
I think that 4G size is and was quite common for a database even when mysql 3or 4 appeared and somebody must figure it out how to do it or maybe even mysql knows how to do this and to work with splited table data files after that.


Thanks a lot!
ra

 

[KingSlick]

Well I came across this problem also. However, we needed to do it more because of a query time issue.

But basically what I would recommend is split the table into 2 tables. Keep one table near 3.5gB size. Then create another table that has a very similar name (I did the following...main_table.myd and main_table_new.myd). Then in all of the queries, I would have a UNION on the 2 tables and it would select the data from both tables.

Now if the table that you are trying to split is not going to grow much, if any, then just split them in half. And still use the UNION queries.

Hope that helps

-SM