MySQL Forums
Forum List  »  Partitioning

Re: How can I decide which partition type can I chose
Posted by: Rick James
Date: September 13, 2010 11:03AM

SHOW CREATE TABLE, please.

"But we need a solution to partition the data because of the size the table grows." -- You can have a non-partitioned table of virtually any size. I need a better reason. And the "reason" will help lead to which partition type to pick.

What do you mean by "archive"? Copy to another table, then delete from this table? Or simply delete from this table?

Also, what will the SELECTs look like? This is important in picking a partition type.

If you already have some data, please do
SHOW TABLE STATUS LIKE 'tbl' \G

| MSG | longtext | YES | | NULL | |
"Vertical partitioning" may be a better thing to do. What is the average size of this field? Do you ever fetch more than one row when fetching MSG?

| ID | varchar(50) | NO | PRI | 0 | |
What kind of value is it? A GUID? Something else?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How can I decide which partition type can I chose
1719
September 13, 2010 11:03AM


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.