sure, i am inserting the data with:
LOAD DATA LOCAL INFILE 'lightning-data.txt' INTO TABLE strikes;
does that clear things up? i assume that the data is first inserted into the
table and then the index is created afterwards. following the creation of the
database files i see that first one is
Hi Andrew,
Since the default storage engine is myisam, increase the below parameter and
then try your index operation.
myisam_sort_buffer_size. This parameter is used for index creation in
myisam.
Also
Set key_buffer to 5 - 50% of your RAM depending on how much
you use MyISAM tables, but keep
At 03:23 AM 4/2/2007, you wrote:
sure, i am inserting the data with:
LOAD DATA LOCAL INFILE 'lightning-data.txt' INTO TABLE strikes;
does that clear things up? i assume that the data is first inserted into
the table and then the index is created afterwards.
Only if the table is empty when
Could you post the actual code you are using for the INSERT? Also, what
storage engine are you using?
Jay
andrew collier wrote:
hello,
i am having some trouble getting mysql to perform decently on my machine. it is
a 2 GHz dual core AMD 64 machine (although i am presently running a 32 bit
hello,
i am having some trouble getting mysql to perform decently on my machine. it is
a 2 GHz dual core AMD 64 machine (although i am presently running a 32 bit
linux system) with 1 Gb RAM and 1 Gb swap partition. the data i am using is
loaded into a table described by:
CREATE TABLE IF NOT