'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
