[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 1.2.3.4
bbb NS 5.6.7.8

meaning that aaa has DNS pointed to 1.2.3.4 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 :)

LOL

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