[Maria-discuss] Increasing InnoDB page size in 10.1

2014-07-14 Thread Tim Callaghan
I'm curious as to the reasoning behind this feature. I assumed it was to get better compression, but the kb page states that compression will not be supported on the new

Re: [Maria-discuss] Increasing InnoDB page size in 10.1

2014-07-15 Thread Tim Callaghan
Thanks, that is helpful. It would be good to capture this (and any other technical advantages) in the KB page itself. On Tue, Jul 15, 2014 at 3:44 AM, Jan Lindström wrote: > Hi, > > We had a customer request to increase the page size for uncompressed pages > to allow more blob fields in a table

Re: [Maria-discuss] Increasing InnoDB page size in 10.1

2014-07-15 Thread MARK CALLAGHAN
I prefer to not give up compression to get larger pages. We might see support for 32kb pages with compression in another variant of MySQL. Benefits from larger pages include 1) fewer seeks for full table scans, 2) more large blob columns stored inline and 3) (maybe) larger index keys. I think #2 ca