split mymql file

[mia456789]

I hv a mysql db in my RH linux , there is a very large table in the
db , the file size is about 2G , how can I split the file into two
files - two files physically and one file logically ? is there any
tools to do it ? thx

[Bill Karwin]

mi*******@yahoo.com.hk wrote:

I hv a mysql db in my RH linux , there is a very large table in the
db , the file size is about 2G , how can I split the file into two
files - two files physically and one file logically ? is there any
tools to do it ? thx

I can't find any mention of storing a single table in multiple physical
files with the MyISAM table type. There's myTable.frm for the table
definition, myTable.MYD for data, and myTable.MYI for indexes.

For InnoDB, you can define multiple data files, but as far as I can tell
from the docs, all logical tables in the database share the same
tablespace. So you probably have no control over which table's data is
stored in which files. I'm no InnoDB expert, but if it's like some
other RDBMS products I've used, then over time most of your tables are
stored non-contiguously, scattered throughout the files, as space is
freed up by deletes and reclaimed by new inserts.

Regards,
Bill K.