On Fri, Aug 31, 2001 at 03:36:14PM -0700, Jeff Leung wrote:
[snip]
> Also, will ALTER TABLE table TYPE=MYISAM create a new temporary
> table to work with and then essentially insert all the rows into the
> new copy before removing the old table?
It will.
> (I am well past 50% capacity on the machine, so if so, this
> operation will probably fail.)
Ugh. Not fun.
One thing I try to do as a rule is make sure I always have enough free
disk space to handle a second copy of my largest table (.MYI and .MYD
files) plus a few percent. Otherwise you risk running into problems
like this.
> Finally, how does MySQL handle resizing database files? Is growth
> linear, or are there specific quanta or thresholds at which the
> table will grow (for example, maybe the table file size will be
> doubled if the table file is over 75% utilized)?
MyISAM files only grow when they need more room, and they only grow
enough to hold new data you're trying to insert. So it's linear.
There are a few bytes of overhead here and there, but that's not going
to be significant.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 3 days, processed 33,362,507 queries (111/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