Extreme low troughput using MySQL + micronaut Data JDBC

[PedroEsnaola]

Thanks for reporting an issue for Micronaut Data, please review the task list below before submitting the issue. Your issue report will be closed if the issue is incomplete and the below tasks not completed.

NOTE: If you are unsure about something and the issue is more of a question a better place to ask questions is on Stack Overflow (http://stackoverflow.com/tags/micronaut) or Gitter (https://gitter.im/micronautfw/). DO NOT use the issue tracker to ask questions.

Task List

• [ y] Steps to reproduce provided
• [ y] Stacktrace (if present) provided
• [ y] Example that reproduces the problem uploaded to
• [ y] Full description of the issue provided (see below)

Steps to Reproduce

1. run project with graddle run
2. start mysql database on docker container
3. run jmeter test

Expected Behaviour

i expect one acceptable troughput, between 2k and 5k req/s

Actual Behaviour

run any Jmeter Load test, when accessing the database, the troughput should be on average 60 req/s

Environment Information

• Operating System: Windows 10 Pro 1903
• Micronaut Version: last stable, generated by Micronaut cli 2 days ago
• JDK Version: 13.0.1

Example Application

• TODO: https://github.com/PedroEsnaola/micronautSample

[graemerocher]

Micronaut Data JDBC (as per the name) uses JDBC which is based on blocking I/O. Your example is doing all blocking I/O on a single thread hence why you are getting low throughput.