0

We are using AWS Aurora 2.x database ( compatible with MySQL 5.7 ). From our application, we are interacting with database using hibernate. In one scenario, we want to use a custom value instead of the default one ( 50 seconds ).

I was able to change the value from MySQL work bench but not with Session/Transaction/Query class methods that belong to hibernate.

user93916
  • 1
  • 2
  • I consider 50 ridiculously high; I hope you are not trying to raise it. If so, explain your application; maybe we can discuss a workaround. – Rick James May 10 '23 at 04:25
  • Thank you James for looking into this. No we do not want to raise this. At application end, we want to set a less value like 10 seconds. We use Aurora Mysql database ( Compatible with MySQL 5.7 ) and in our application we use hibernate (version 3.x ) to connect with it. – user93916 May 17 '23 at 17:02
  • Aurora may have a way to change the configuration. – Rick James May 17 '23 at 17:13
  • Thank you a lot for the prompt reply. Yes. From Aurora end, we can update the lock wait time out. Are there no other ways can we do that from Hibernate end? Does hibernate 3.x do not support it for MySQL or no hibernate version supports these for MySQL? – user93916 May 17 '23 at 18:17
  • Random clue: sys.ps_setup_save – Rick James May 17 '23 at 21:07
  • Hi Rick, One observation: When the rows are locked for write operation, insert queries also waiting for the lock to release. We have not locked using primary key. May I know what's happening. – user93916 May 22 '23 at 19:59
  • Connect as root and do `SHOW FULL PROCESSLIST`. It may provide more clues. – Rick James May 22 '23 at 22:27

0 Answers0