I am trying to understand the variables:
As I understand the innodb_log_file_size is for undo and redo purposes for when cancelling a transaction and for when server crashes. Does this mean that I can kind of ignore this if I don't plan on writing queries of the form:
START TRANSACTION; UPDATE accounts SET balance = balance + 100 WHERE account_id = 98; UPDATE accounts SET balance = balance - 100 WHERE account_id = 42; COMMIT;
I also heard somewhere that
Every INSERT, UPDATE, DELETE is a transaction if autocommit=1.
What does this mean?
If I do zero transactions, will I gain any performance by setting
innodb_flush_log_at_trx_commit=0? Since I won't need to sync after every transaction commit. But again I heard on youtube that if autocommit=1, then every insert, update, and delete "is a transaction".
I am confused.