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
5099
September 01, 2010 11:17PM
1926
September 02, 2010 04:09AM
Re: Do I have to re write querries when Partitioning?
2097
September 03, 2010 07:26PM
5625
September 05, 2010 07:43PM
2245
September 05, 2010 07:45PM
9742
September 05, 2010 07:47PM
3952
September 05, 2010 07:51PM
2001
September 05, 2010 07:52PM
3929
September 05, 2010 07:52PM
1784
September 06, 2010 11:38PM
2417
September 06, 2010 11:39PM
3492
September 08, 2010 11:33AM
1851
September 10, 2010 08:00PM