> -----Original Message-----
> From: Nick Arnett [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 21, 2002 3:39 PM
> To: [EMAIL PROTECTED]
> Subject: How to speed up mods to large table?
>
>
> I haven't been able to dig up any specific information about how to get
> maximum performance when making changes to large tables. I have a table
> that's close to 4 GB, which I'm altering to come up with the best
> trade-off
> between performance and speed. Dropping a column or an index seems
> exceedingly slow and I'm wondering what parameters matter for this.
To answer my own question, at least in part... since I'm using MySQL 4.0.1,
I'm trying the same operation again after doing "alter table... disable
keys". That appears to make it much, much faster.
Strangely, though, it's not using the temporary directory that I gave it in
my.ini with the "tmpdir" variable. I seem to recall having that problem
before, but I don't know what solved it.
Nick
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
