Turn Off Autocommit By Default

[danielh]

Is there any way of having an option to tell SQLYog to turn off autocommit by default upon login? I know I can issue a “set autocommit=0”, but it is easy to forget, and I don't want to run the risk of having it turned on when working on a production system.

/D

[peterlaursen]

Currently you will have to execute it manually. We have discussed before solutions like:

1) an option for user to specify queries to be executed at connection time.

2) some GUI-element (like icons/bottons) for start transaction/commit/rollback

.. you are welcome to comment on that.

We will not make “set autocommit=0” because it will break backwards compatibility and also it will have no effect with non-transactional engines (MyISAM first of all).

[danielh]

“an option for user to specify queries to be executed at connection time.” – sounds perfect to me!

[adam8a]

'danielh' wrote:

Is there any way of having an option to tell SQLYog to turn off autocommit by default upon login? I know I can issue a “set autocommit=0”, but it is easy to forget, and I don't want to run the risk of having it turned on when working on a production system.

/D

Hi,

I'd really appreciate a button that could toggle autocommit ON/OFF.

a. The claim that it will have no effect of non-transactional Engines like MyISAM

is becoming less relevant. All the recent development of MySQL has been on the transactional

engines like InnoDB. Look at versions 5.5 and 5.6.

As MyISAM is being neglected by Oracle, many are even recommending InnoDB for Data Warehouses.

b. Also, tools like Toad for MySQL have such a button and it is a great safety feature.

By default, you set your options/preferences to have autocommit off

because you want a read-only view of your production DB.

To actually make lasting changes you must actively COMMIT

them.

When you are playing in your sandbox, you can turn the autocommit on if you want.

I'm sure this feature would be very much welcomed by all of your users.

thanks,

adam

[peterlaursen]

We plan to implement an option for users to specify MYSQL_INIT_COMMAND's (refer http://dev.mysql.com/doc/refman/5.5/en/mysql-options.html) very soon. This is for users connecting to a server running with some rare startup option including “init-command = 'SET AUTOCOMMIT = 0' .

As regards GUI controls for managing transactions we have alrady registered this: http://code.google.com/p/sqlyog/issues/detail?id=1526 . This is not yet scheduled. Workaround is to execute BEGIN/START TRANSACTION/ SET AUTOCOMMIT = 0 from the editor and COMMIT from there as well.

[Author]

Posts