maria-discuss team mailing list archive

[Jeremy Cole <jeremycole@xxxxxxxxxx>]

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@xxxxxxxxx>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@xxxxxxxxx>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@xxxxxxxxxxx>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
>>>
>>> [image: Twitter] <http://twitter.com/skysql> [image: Blog]<http://www.skysql.com/blog/>
>>>  [image: Facebook] <http://www.facebook.com/skysql> [image: LinkedIn]<http://www.linkedin.com/company/1214250>
>>>  [image: Google+] <https://plus.google.com/117544963211695643458/posts>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~maria-discuss
>>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>