[thelist] Very Large MySQL Table

Fred Jones fredthejonester at gmail.com
Tue Feb 10 13:57:41 CST 2009

> Converting a table from one storage engine to another (among other
> operations), will use typically 2 * table-size and gallons of RAM - so this
> won't work, especially on a small box.

Right you are. :0

> But why not create the table and do
> the import as MyISAM (not sure the format of the data you're actually being
> supplied with)?

Data is a flat text file like this:

aaa NS
bbb NS

meaning that aaa has DNS pointed to etc.

> They don't use relational databases - relational databases are relatively
> slow in the "database" world.

Aha. Makes sense.

> Oh, and they don't use a shared web hosting account :)


OK, now I know their secret. ;)

I am going to upload the zipped flat file to the server and try to do
it there. Thanks.

More information about the thelist mailing list