[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