tag:blogger.com,1999:blog-14455177.post3834543859505234267..comments2024-03-07T18:57:25.977+01:00Comments on Mikael Ronstrom: Improvement of MySQL partitioning included in MySQL's next milestone release treeMikael Ronstromhttp://www.blogger.com/profile/07134215866292829917noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-14455177.post-28792043451258448152009-11-14T12:22:37.515+01:002009-11-14T12:22:37.515+01:00Sounds good that you want to try out multiple stor...Sounds good that you want to try out multiple storage engines in one table. The reason why it's not supported is mainly the problems it creates in the handler interface. Just one example is the table and index flags. If those flags differ on different partitions you need to decide what to respond to the MySQL Server. There are many similar cases that one would have to consider how to resolve.Mikael Ronstromhttps://www.blogger.com/profile/07134215866292829917noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-2977846489895596692009-11-13T17:22:27.086+01:002009-11-13T17:22:27.086+01:00I was skeptical about many of the new features in ...I was skeptical about many of the new features in 5.1. Now I can't wait to use them.<br /><br />I still want to use multiple engines in one partitioned table and that is probably something I will try to add.Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-69617808735701291502009-11-10T19:22:23.937+01:002009-11-10T19:22:23.937+01:00Cool! Though as a logistical issue, I had to clic...Cool! Though as a logistical issue, I had to click through my RSS feed and read several paragraphs to actually find out what the <br /><br />(in my opinon, blog posts should be like newspaper articles, and a good summary of what the article is about should appear above the "fold"....otherwise you lose people who don't want to click through because they don't know what the new partitioning feature is, and aren't THAT excited about it....but might be if they knew what it was!)<br /><br /><br />this could very well be the 2nd paragraph, instead of the 5th one:<br /><br />"The major advantages of this new feature is that it makes it<br />possible to partition on string fields and also to partition on<br />multiple fields and still get good partition pruning. Previous<br />partitioning required a partition function that delivered an<br />integer result and a couple of functions could deliver good<br />partition pruning."Sheeri K. Cabralhttps://www.blogger.com/profile/13990877688502800403noreply@blogger.com