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.
Why? Have you looked at MyISAM MERGE tables yet? They're a style of "partitioning" that MySQL lets you play with. > Do InnoDB tables support partitioning? No. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 3 days, processed 111,370,017 queries (345/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