I changed the value of system variable 'sort_buffer_size' inside a transaction
block. After issuing rollback, it is not getting reverted. Please see the below
snapshot:
please see the below snip regarding what I did in my local machine MySQL 5.7
server
Asked
Active
Viewed 27 times
0
Pavan Teja
- 21
- 3
1 Answers
0
Because these statements do not change any data, only the configuration of the mysql server, therefore they are not part of the transaction. This is the normal behaviour.
As mysql documentation on SET statement says:
If you change a session system variable, the value remains in effect within your session until you change the variable to a different value or the session ends. The change has no effect on other sessions.
If you change a global system variable, the value is remembered and used for new sessions until you change the variable to a different value or the server exits.
Shadow
- 33,525
- 10
- 51
- 64
-
Thank youu soo much for your timely response – Pavan Teja Jun 14 '17 at 06:15