Skip navigation links

MySQL Forums :: Partitioning :: How to partition my table


Advanced Search

How to partition my table
Posted by: Maron Vomr@ ()
Date: March 15, 2009 09:36AM

HI all,
I am new to partitioning in mysql and willing to know how to partition my following table with structure as below:

logdate datime not null default '0000-00-00 00:00:00',
ip varchar(15) not null,
size decimal(20,2) unsigned not null default '0.00'
url text not null,
user varchar(25) not null default '',
mime char(15) default null,
extension char(10) not null default '',
PRIMARY KEY(logdate,user)


Which stores logs of proxy around 1GB per day. Now how to break down this table with partitioning.

Thank you.

Options: ReplyQuote


Subject Views Written By Posted
How to partition my table 8045 Maron Vomr@ 03/15/2009 09:36AM
Re: How to partition my table 3879 Rick James 03/15/2009 01:09PM
Re: How to partition my table 3196 Maron Vomr@ 03/17/2009 10:35PM
Re: How to partition my table 2889 Rick James 03/18/2009 12:16AM
Re: How to partition my table 2755 Maron Vomr@ 03/18/2009 09:12PM
Re: How to partition my table 2741 Rick James 03/18/2009 10:19PM
Re: How to partition my table 2861 Maron Vomr@ 03/19/2009 05:18AM
Re: How to partition my table 2976 Aftab Khan 03/19/2009 05:34AM
Re: How to partition my table 2629 Raghavendra Jha 04/06/2009 08:08AM
Re: How to partition my table 3001 Maron Vomr@ 04/07/2009 09:44PM
Re: How to partition my table 2093 Rick James 04/08/2009 08:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.