maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

'transactional' in Aria will eanable crash recovery for the table.  It will
not make the table transactional (ie. START TRANSACTION, COMMIT, ROLLBACK
etc.) are still ignored.  Probably it was originaly intended to have it
trasactional over time but I do not think focus is there at the moment.

Byt yes .. it is just a checkbox and would be simple to add to any GUI
(conditionally if engine = ARIA). But I think that if people want
(user-)tables with the Aria engine you would use '1' in most if not all
cases (temproary tables created by server internally is another thing).

-- Peter


On Wed, Aug 31, 2011 at 07:47, Ansgar Becker
<ansgar.becker@xxxxxxxxxxxxxx>wrote:

>  Hi all,
> I'm a bit unsure what this option really does, now that Peter said it
> doesn't make a table transactional, but I'm sure there is a reason for why
> it exists. So I'll see if I can add a checkbox right besides the engine drop
> down, which is enabled only if Aria is selected. Also I need to read out
> this attribute in existing tables, which needs some adjustment in my CREATE
> TABLE parser.
>
> Ansgar
>
> Am 30.08.2011 19:31, schrieb Peter Laursen:
>
> We have the same request for SQLyog:
> http://code.google.com/p/sqlyog/issues/detail?id=538
>
>  Of course a client is never engine-specific.  But that is not the same
> that a client has GUI fucntionalities to su
>
>  @Vlad you probably know that your company (Monty Program) and mine
> (Webyog) are partners (what means customers will gain a rebate to our
> products when comming from Monty Program website.  Check it out or ask Monty
> himself).  Not that I would mind that Ansgar adds this to Heidi. But
> basically we never found it very important.  Even if ARIA is set to
> transactioanl = 1 , it is not transactional.  it has crash recovery what is
> not the same.
>
>
>  Peter
> Webyog
>
> On Tue, Aug 30, 2011 at 19:11, Vladislav Vaintroub <wlad@xxxxxxxxxxxxxxxx>wrote:
>
>> I'm forwarding this to Ansgar, as a feature request for HeidiSQL. May be
>> tricky to add it as Aria-specific option,  currently  CREATE TABLE
>> options/checkboxes  in HeidiSQL seem to be not engine dependent to me.
>>
>> > -----Original Message-----
>> > From: maria-discuss-
>> > bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx [mailto:maria-
>> > discuss-bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx] On Behalf
>> > Of Daniel Bartholomew
>> > Sent: Dienstag, 30. August 2011 18:50
>> > To: Maria Discuss
>> > Subject: [Maria-discuss] GUI/Workbench for MariaDB Aria?
>>  >
>> > New question on the Knowledgebase:
>> >
>> > http://kb.askmonty.org/en/guiworkbench-for-mariadb-aria
>> >
>> > Does anybody know a good GUI/Work bench tool to handle ARIA
>> > transactional=1/0 and row_format=PAGE situations?
>> >
>> > Thanks.
>> >
>> > --
>> > Daniel Bartholomew
>> > MariaDB - http://mariadb.org
>> > Monty Program - http://montyprogram.com
>> > AskMonty Knowledgebase - http://kb.askmonty.org
>> >
>> >
>> > _______________________________________________
>> > 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
>>
>
>
>