Jan,

I think "InnoDB file space defragmentation" could use significantly more explanation.

By my understanding, delete-marked rows are in fact "physically deleted" (re-linked to the garbage record list) during purge. However, the garbage records in the list are not reclaimed unless: a. the first record in the list has enough usable space for a newly inserted records (potentially leaving some of the record's space unused); or b. the page becomes full and gets re-organized, freeing all garbage space implicitly. Of course then even in the best case the page is still "used" and not free.

Freeing unused file space is an entirely different problem, involving potentially relocating used pages to be more contiguous, and then reducing the free limit and then the page count for the space.

They seem to be entirely different problems and without much overlap at all. They are both potentially useful, and interesting. (Although I am not sure why to make it an external tool as opposed to internal functionality, that seems unnecessary.)

Can you explain your ideas/goals for this?

Regards,

Jeremy

On Fri, Apr 11, 2014 at 9:41 AM, Pantelis Theodosiou <ypercube@gmail.com> wrote:

Adam, you are right, bulk load project is 5835:

(2) InnoDB fast bulk load
    Description: External tool to load CVS file directly to InnoDB file space (innodb_file_per_table = 1).
https://mariadb.atlassian.net/browse/MDEV-5835

On Fri, Apr 11, 2014 at 5:28 PM, Adam Scott <adam.c.scott@gmail.com> wrote:

Second link is the same as the first one: MDEV-5834

On Wed, Mar 12, 2014 at 5:59 AM, Jan Lindström <jplindst@mariadb.org> wrote:

Hi all,

After careful weighting and selection process, I have selected following two projects as a starting point to improve InnoDB

(1) InnoDB file space defragmentation
    Description: External tool to physically delete delete marked rows from InnoDB file space and freeing unused file space.
    https://mariadb.atlassian.net/browse/MDEV-5834

(2) InnoDB fast bulk load
    Description: External tool to load CVS file directly to InnoDB file space (innodb_file_per_table = 1).
    https://mariadb.atlassian.net/browse/MDEV-5834

Now, I hope these projects mostly represent the most frequently requested features and are most usable to current customers and/or potential new customers. Next, I would hope some indication which one of the selected project you would like to see first. Votes can be added above links.

R:

--

Jan Lindström, Principal Engineer
SkySQL - The MariaDB Company

MariaDB | MaxScale | skype: jan_p_lindstrom

www.skysql.com



_______________________________________________
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

_______________________________________________
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

_______________________________________________
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