transaction-bufferMB, then writes block until there is space available. Both MongoDB and MySQL are often run with similar configurations.
show statusquery as
Transaction_buffer_wait_time.This value measures the cumulative amount of time transaction threads have blocked trying to insert into the transaction buffer. The default size of the transaction buffer, 128 MB, is a heuristic: most disks can easily sequentially write 128 MB/s, so you shouldn’t lose more than a second of data. Visit the durability page in our documentation for more information.
Description of the benchmark
- Players. Every player has an ID, and two statistics: the number of games started and the number of games won.
- Games. Each game has an ID, two players and a turn.
- Game length statistics. We store a histogram of finished game lengths, composed of a game length and an integer counting the number of games.
- Events. Finally, every action performed is stored as an up to 32-character description, together with a timestamp and a player ID.
default-storage-engine=INNODB innodb_buffer_pool_size = 4GB innodb_log_file_size = 128M innodb_log_buffer_size = 4M innodb_flush_log_at_trx_commit=2 innodb_thread_concurrency=0 innodb_flush_method=O_DIRECT innodb_file_per_table