[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: partitionong MyISAM tables??
From:       "Stefan Hinz, iConnect \(Berlin\)" <list_hinz () iConnect ! de>
Date:       2003-01-31 22:03:57
[Download RAW message or body]

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 <hinz@iConnect.de>
  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" <pkrishna@novell.com>
To: <mysql@lists.mysql.com>
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 <mysql-thread131297@lists.mysql.com>
> To unsubscribe, e-mail
<mysql-unsubscribe-list_hinz=iconnect.de@lists.mysql.com>
> 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 <mysql-thread131392@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]