How to partition my table
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.
Subject
Views
Written By
Posted
How to partition my table
10345
March 15, 2009 09:36AM
4733
March 15, 2009 01:09PM
4000
March 17, 2009 10:35PM
3616
March 18, 2009 12:16AM
3455
March 18, 2009 09:12PM
3432
March 18, 2009 10:19PM
3760
March 19, 2009 05:18AM
3722
March 19, 2009 05:34AM
3419
April 06, 2009 08:08AM
3945
April 07, 2009 09:44PM
2772
April 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.