'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@googlemail.com> 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:
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@montyprogram.com>
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@lists.launchpad.net
[mailto:maria-
> discuss-bounces+wlad=montyprogram.com@lists.launchpad.net]
On Behalf
> Of Daniel Bartholomew
> Sent: Dienstag, 30. August 2011 18:50
> To: Maria Discuss
> Subject: [Maria-discuss] GUI/Workbench for MariaDB Aria?