On Wed, May 16, 2001 at 10:58:18PM +0200, Frank Schroeder wrote:
>
> Is there a way of turning the transactional logging off during the
> load of a table? I know that I'm out on my own then but this table
> is loaded only every once in a while.
>
> Am I running out of space on the log/or data files?
If InnoDB doesn't already handle this, it's probably a good idea not
to run ALTER TABLE as a big transaction. It's slow and probably not
necessary.
I ran across this with Gemini testing, and NuSphere modified things so
that ALTER TABLEs don't hit the recover log anymore. (After all, what
use is a half altered table?)
InnoDB, however, may be sufficiently different (with mutli-versioning)
that it's not as much of an issue.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 133 days, processed 825,899,259 queries (71/sec. avg)
---------------------------------------------------------------------
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