|
Replies:
1
-
Pages:
1
-
Last Post:
Nov 18, 2011 12:17 PM
by: Mauritz
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
7
Registered:
3/22/11
|
|
|
|
best transaction commit config for MySQL
Posted:
Nov 17, 2011 11:05 AM
|
|
|
love toad for mysql (for sql server and oracle for that matter).
I use toad for mysql v6.0.0 to connect to MySQL 5.5 (primarily MyISAM tables).
I am trying to find the best way to configure toad for working with transactions
for basic select and update statements.
The default setting will prompt after a while whether I want to keep or rollback a transaction. I thought my updates have aleady been commited by MySQL. Weren't they?
So I tried setting AutoCommit off but now when I close the editor I am getting an alert saying you have uncommited changes. I hope this isn't true. I hope that all changes have been commited.
What's the best way here?
Thanks,
Nic
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: best transaction commit config for MySQL
Posted:
Nov 18, 2011 12:17 PM
in response to: nic chidu
|
|
|
Just FYI you are aware that MyISAM tables do not support transactions at all so the auto commit setting of Toad does not have any effect as long as this kind of table is used.
Also MySQL does not have any way of determining if an open transaction exist so we have to prompt if Auto Commit is off because we really don't know if a transaction exists (Keep in mind that just executing a SELECT can start a transaction).
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
