'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:

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@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?

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@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