MySQL Forums
Forum List  »  Partitioning

Simply MySQL Partition on One Column (groupID)
Posted by: Andrew Barlow
Date: August 20, 2012 07:43AM

I have a large-ish table (over 10 million rows) - we'll call this table "rowData". I have the following columns; "rowId", "groupId" and "textString". The ID's are both ints and "textString" is a simple varchar. I only have a maximum of 50 groupId's at a time which are stored in another table (possibly not of interest), but the groupID's are NOT sequential (rowId is AUTO_INCREMENT and the PRIMARY KEY).

What I would like to do, is to partition my table on these groupID's. I know what the list of groupIDs are (IE. 2342, 5251, 1591, 5915 etc etc). How would I go about doing this (sample code anyone?) and would I have to add a new partition to my "rowData" table every time I add a new "groupId" to my group table (not discussed in detail here)?

Running version 5.5.23


Options: ReplyQuote

Written By
Simply MySQL Partition on One Column (groupID)
August 20, 2012 07:43AM

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.