Re: Do I have to re write querries when Partitioning?
Posted by:
Rick James
Date: September 03, 2010 07:26PM
PRIMARY KEY (`id`), -- Yes, id is your PK
KEY `part_of_keywords` (`keywords`(30)), -- here's on INDEX
KEY `part_of_category` (`category`), -- here's another
KEY `part_of_country` (`country`(10)),
KEY `part_of_zip` (`zip`),
"INDEX" == "KEY"
PARTITION would make it fast to dump old records. You can probably do that with an ALTER PARTITION instead of DELETE.
To establish partitioning on the table, you would have to make some kind of clumsy change to the PRIMARY KEY.
No changes to INSERT, SELECT, etc are needed.
Any SELECT that does not reference what you are partitioning on will have to search every partition. This means that it is no faster, possibly slower, than if you had a single table.
What do your SELECTs look like?
SHOW TABLE STATUS LIKE 'yspnash_auctions' \G
Subject
Views
Written By
Posted
5150
September 01, 2010 11:17PM
1947
September 02, 2010 04:09AM
Re: Do I have to re write querries when Partitioning?
2120
September 03, 2010 07:26PM
5651
September 05, 2010 07:43PM
2269
September 05, 2010 07:45PM
9780
September 05, 2010 07:47PM
3988
September 05, 2010 07:51PM
2026
September 05, 2010 07:52PM
3958
September 05, 2010 07:52PM
1815
September 06, 2010 11:38PM
2448
September 06, 2010 11:39PM
3523
September 08, 2010 11:33AM
1872
September 10, 2010 08:00PM