On Fri, Jan 31, 2003 at 04:36:05AM -0700, Prasanth Krishna wrote: > Is there any way to partition MyISAM tables in mysql? i have a huge > table and want to partition it.
Good Day Prasanth, The MERGE table handler allows multiple MyISAM tables with identical structure (but different data) to be presented as a single database. This is similar to range partitioning. Visit http://www.mysql.com/doc/en/MERGE.html for more information. > Do InnoDB tables support partitioning? > thanks. AFAIK InnoDB does not support partitioning. -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Nuernburg, June 02-06, 2003 Visit http://mysql.com/training for more information Debian: Yep, that's GNU/Linux (http://debian.org) --------------------------------------------------------------------- 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
