Re: [Maria-discuss] Increasing InnoDB page size in 10.1
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 <jan.lindstrom@skysql.com> wrote:
Hi,
We had a customer request to increase the page size for uncompressed pages to allow more blob fields in a table. This request is satisfied by this implementation. While I was doing this enhancement, I did try to increase the page size for compressed pages also but this proved too hard for time constraints I had. I did try to discuss about the problems with only person I know who really knows how compressed pages storage format is implemented (Marko Mäkelä) but unfortunately, I did not get it to work with limited help I received. As soon as I have again time, I will revisit this issue and see what I can do.
R: Jan
On Mon, Jul 14, 2014 at 4:07 PM, Tim Callaghan <tmcallaghan@gmail.com> wrote:
I'm curious as to the reasoning behind this feature. I assumed it was to get better compression, but the kb page <https://mariadb.com/kb/en/mariadb/mariadb-documentation/mariadb-storage-engines/xtradb-and-innodb/xtradbinnodb-storage-formats/> states that compression will not be supported on the new 32K and 64K page size.
-Tim Callaghan
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
--
--
Jan Lindström, Principal Engineer SkySQL - The MariaDB Company
skype: jan_p_lindstrom
www.skysql.com <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2F&sa=D&sntz=1&usg=AFrqEzcZuouapPzP5SJcV6B_sk4rcBAMZw>
[image: Twitter] <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fskysql&sa=D&sntz=1&usg=AFrqEzc4-Qr1r8d_c0K_9PGkw3O126J68A> [image: Blog] <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2Fblog%2F&sa=D&sntz=1&usg=AFrqEzfHybQaBaAQIalfuAv9g8QhxaEF-A> [image: Facebook] <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&sntz=1&usg=AFrqEzc4Kk2TUyZinWuhXhn5uMDEfa-TRw> [image: LinkedIn] <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1214250&sa=D&sntz=1&usg=AFrqEzezWUya7565tGaMEx0C4Mu7a0Gjcg> [image: Google+] <https://plus.google.com/117544963211695643458/posts>
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 can be a big deal for saving space. On Tue, Jul 15, 2014 at 7:15 AM, Tim Callaghan <tmcallaghan@gmail.com> wrote:
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 <jan.lindstrom@skysql.com> wrote:
Hi,
We had a customer request to increase the page size for uncompressed pages to allow more blob fields in a table. This request is satisfied by this implementation. While I was doing this enhancement, I did try to increase the page size for compressed pages also but this proved too hard for time constraints I had. I did try to discuss about the problems with only person I know who really knows how compressed pages storage format is implemented (Marko Mäkelä) but unfortunately, I did not get it to work with limited help I received. As soon as I have again time, I will revisit this issue and see what I can do.
R: Jan
On Mon, Jul 14, 2014 at 4:07 PM, Tim Callaghan <tmcallaghan@gmail.com> wrote:
I'm curious as to the reasoning behind this feature. I assumed it was to get better compression, but the kb page <https://mariadb.com/kb/en/mariadb/mariadb-documentation/mariadb-storage-engines/xtradb-and-innodb/xtradbinnodb-storage-formats/> states that compression will not be supported on the new 32K and 64K page size.
-Tim Callaghan
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
--
--
Jan Lindström, Principal Engineer SkySQL - The MariaDB Company
skype: jan_p_lindstrom
www.skysql.com <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2F&sa=D&sntz=1&usg=AFrqEzcZuouapPzP5SJcV6B_sk4rcBAMZw>
[image: Twitter] <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fskysql&sa=D&sntz=1&usg=AFrqEzc4-Qr1r8d_c0K_9PGkw3O126J68A> [image: Blog] <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2Fblog%2F&sa=D&sntz=1&usg=AFrqEzfHybQaBaAQIalfuAv9g8QhxaEF-A> [image: Facebook] <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&sntz=1&usg=AFrqEzc4Kk2TUyZinWuhXhn5uMDEfa-TRw> [image: LinkedIn] <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1214250&sa=D&sntz=1&usg=AFrqEzezWUya7565tGaMEx0C4Mu7a0Gjcg> [image: Google+] <https://plus.google.com/117544963211695643458/posts>
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Mark Callaghan mdcallag@gmail.com
participants (2)
-
MARK CALLAGHAN -
Tim Callaghan