Prasanth, > Is there any way to partition MyISAM tables in mysql? i have a huge > table and want to partition it.
An easy way to slice it into chunk would be: CREATE TABLE tblPart_1 SELECT * FROM tblFull LIMIT 0,1000; CREATE TABLE tblPart_2 SELECT * FROM tblFull LIMIT 1000,1000; CREATE TABLE tblPart_3 SELECT * FROM tblFull LIMIT 2000,1000; etc. With InnoDB tables, you can do exactly the same. If you need the tables to look like one big table later on you can use the MERGE table format (if your tblPart_* are MyISAM tables). CREATE TABLE tblFullMerge (col1 ..., col2 ..., ...) TYPE=MERGE UNION(tblPart_1,tblPart2,...); With InnoDB, you cannot use MERGE tables. I don't know if that's what you want. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Prasanth Krishna" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 12:36 PM Subject: partitionong MyISAM tables?? > Is there any way to partition MyISAM tables in mysql? i have a huge > table and want to partition it. > Do InnoDB tables support partitioning? > thanks. > Prasanth > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
