tag:blogger.com,1999:blog-14455177.post115903964428950453..comments2024-03-07T18:57:25.977+01:00Comments on Mikael Ronstrom: State of MySQL partitioningMikael Ronstromhttp://www.blogger.com/profile/07134215866292829917noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-14455177.post-5901832131917779442011-12-26T13:35:24.062+01:002011-12-26T13:35:24.062+01:00Hi Yotke,
It isn't possible to automatically c...Hi Yotke,<br />It isn't possible to automatically create new partitions.<br /><br />If you partition on timestamp, then this needs to be part of all unique indexes.Mikael Ronstromhttps://www.blogger.com/profile/07134215866292829917noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-86135492497818264832011-12-25T12:23:53.624+01:002011-12-25T12:23:53.624+01:00Given table that consists of store_id(unique-index...Given table that consists of store_id(unique-index), partition by range (to_days(timestamp))... <br /><br />It is written that partition must be added to the unique-index since the unique-index is local to a partition. <br />If I am good that the unique constraint will be validated locally per partition, can I leave store_id(unique-index) without the column (timestamp) used for the partitioning?Yotkehttps://www.blogger.com/profile/06778874428290095360noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-26491214860519725442011-12-25T12:14:32.846+01:002011-12-25T12:14:32.846+01:00Hello
Is there a way to assign data to partition...Hello <br /><br />Is there a way to assign data to partition automatically? E.g., in case of to_days(timestamp); do I have to set all options --> <br />...PARTITION p0 VALUES ... <br />PARTITION p1 VALUES... <br />PARTITION p2 VALUES... <br />In my case, I would like the partition number to be set automatically according to the to_days output.Yotkehttps://www.blogger.com/profile/06778874428290095360noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-1159305022230777202006-09-26T23:10:00.000+02:002006-09-26T23:10:00.000+02:00I'll look into what I can do to make themavailable...I'll look into what I can do to make them<BR/>available in some manner or the other.<BR/>I'll post it on the blog when it happens<BR/><BR/>MikaelMikael Ronstromhttps://www.blogger.com/profile/07134215866292829917noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-1159041934505792682006-09-23T22:05:00.000+02:002006-09-23T22:05:00.000+02:00Can we see those presentations ?Can we see those presentations ?Anonymousnoreply@blogger.com