Re: How can I decide which partition type can I chose

[Rick James]

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?