Is there an InnoDB max transaction size and what happens if it is reached?
0
votes
3
answers
1201
views
I would like to know if there is a max transaction size for InnoDB. Probably it is
innodb_log_file_size * innodb_log_files_in_group + innodb_log_buffer_size
? And this max size would be shared between all ongoing transactions?
What happens when this max size is reached? The transaction is aborted?
I ask this question because we are having out of memory issues with our MySQL server, we're running out of ideas to understand the problem, and we wonder if it could be caused by transactions beeing too large.
Asked by FBB
(113 rep)
Sep 28, 2021, 12:45 PM
Last activity: May 7, 2025, 07:02 AM
Last activity: May 7, 2025, 07:02 AM