InnoDB is a sophisticated, mature storage engine. The key to happiness with it is . Measure before tuning, and always test isolation level changes in a staging environment.
Stop tolerating "Lock wait timeout exceeded." Your database will thank you. indodb21
SELECT variable_name, variable_value/1024/1024 AS size_mb FROM performance_schema.global_status WHERE variable_name IN ('Innodb_buffer_pool_bytes_data', 'Innodb_buffer_pool_bytes_dirty'); InnoDB is a sophisticated, mature storage engine