MySQL Forums
Forum List  »  Partitioning

Re: Partitioning help
Posted by: Anantha Varatharajan
Date: October 13, 2010 03:27AM

I will not be having any additional indexes on the table other than primary key. I will be querying the table for a specific row using the primary key column. The select's are very very infrequent.We are looking at inserting 1000 rows / minutes. I am thinking of using myIsam engine. Is that alright?

Table structure - I will be having 4 tables of this type each one for different type of request.

CREATE TABLE tx_http_rq (
rq_n int(11) NOT NULL,
sess_id varchar(40) NOT NULL,
rq_type varchar(40) NOT NULL,
ht_met varchar(100) NOT NULL,
url text NOT NULL,
tx_var longtext,
PRIMARY KEY (rq_n,sess_id,rq_type)
) ENGINE=MyISAM;

thanks rick for your help.

Options: ReplyQuote


Subject
Views
Written By
Posted
3237
September 24, 2010 02:16AM
1730
September 25, 2010 01:09PM
1701
September 27, 2010 03:43AM
1663
September 27, 2010 07:55PM
1619
October 12, 2010 01:55AM
1611
October 12, 2010 08:03AM
Re: Partitioning help
1534
October 13, 2010 03:27AM
1572
October 13, 2010 06:03PM


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.