Skip navigation links

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


Advanced Search

Re: How to partition my table
Posted by: Maron Vomr@ ()
Date: April 07, 2009 09:44PM

Ok, now lets take the real scenario.

With all your suggestions I am now going to study a little further and implement in in mysql-5.1.30
The purpose is to store proxy logs of around 5000 users :D on daily basis.

So I think date wise partitioning will be ok.
I am planning to create a database with 5 tables :
1. Emp details
2. Record of mail sent to user( i.e., when sent,for which date,etc around 5 fields)
3. proxy1
4. proxy2
5. proxy3

Roughly have this table structure in mind for proxy1/2/3
CREATE TABLE `test` (
`dwtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`ip` varchar(15) NOT NULL default '',
`size` float(15,2) unsigned NOT NULL,
`url` text NOT NULL,
`user` varchar(25) NOT NULL default '',
`mime` varchar(25) default NULL,
`extension` varchar(10) NOT NULL default '',
);
Now the issue is what to make the primary key? As dwtime can get duplicated, even the user, even the size too.

Haven't decided the fields. Let me finalize that and then share with you for your suggestions.

Options: ReplyQuote


Subject Views Written By Posted
How to partition my table 8162 Maron Vomr@ 03/15/2009 09:36AM
Re: How to partition my table 3915 Rick James 03/15/2009 01:09PM
Re: How to partition my table 3216 Maron Vomr@ 03/17/2009 10:35PM
Re: How to partition my table 2902 Rick James 03/18/2009 12:16AM
Re: How to partition my table 2768 Maron Vomr@ 03/18/2009 09:12PM
Re: How to partition my table 2750 Rick James 03/18/2009 10:19PM
Re: How to partition my table 2876 Maron Vomr@ 03/19/2009 05:18AM
Re: How to partition my table 2990 Aftab Khan 03/19/2009 05:34AM
Re: How to partition my table 2643 Raghavendra Jha 04/06/2009 08:08AM
Re: How to partition my table 3054 Maron Vomr@ 04/07/2009 09:44PM
Re: How to partition my table 2108 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.