Setting innodb_buffer_pool_size to 2GB for MySQL in CircleCI Jobs

verdict-project / verdict

Interactive-Speed Analytics: 200x Faster, 200x Fewer Cluster Resources, Approximate Query Processing

http://verdictdb.org

Apache License 2.0

248 stars 66 forks source link

Setting innodb_buffer_pool_size to 2GB for MySQL in CircleCI Jobs #319

Closed dongyoungy closed 5 years ago

dongyoungy commented 5 years ago

I have observed that a CircleCi job fails occasionally waiting for MySql tests to finish (e.g., CircleCI job link1, link2)

I think allocating a higher value (=2GB, default is 128MB) for innodb_buffer_pool_size may mitigate this issue and a few test runs from this PR seemed to help.