I am currently trialing BMF 6.81 (build 545). I am using a TPC-E Transaction Mix test (scale 1), to show the difference of performance against MySQL 5.6 and SQL Server 2012.
Comparing the test results of 50 concurrent users running, MySQL shows a TPS amount of 32, while SQL Server shows a TPS amount of 1138.
This is a big difference. I would expect MySQL to be closer to SQL Server. I must be doing something wrong with MySQL, but both test runs are out of the box.
Any ideas how I can improve MySQL TPC-E score or any config changes I should look at?