Database performance tests

- MySQL
- Maria DB
-MSSQL
-PostgreSQL
- MongoDB
-DolphinDB
These are the databases types I want to test for performance.
Create databases servers using docker.

Requierements:
tables structure:
tables structure:
(order table)
public long orderId - PK
public int extSystemId = -1;
public long extId = -1;

public volatile OrderStatus status = OrderStatus.OPEN
public long refCustomerId;
public int volume;
public long limitPrice;
public long stopPrice;
public long creationDate;
public long validTo;
public OrderSide side;
public OrderType type; // type (market, limit ...)

table (order history)
order_history_id long PK (auto increment)
order_id lon FK
user_id int
creation_time timestamp
action int


Project name ss-trading
I want to make performance tests with and display in histogram:
For each type of database I want to test:
-inseration time for x records (configurable parameter using picoclient)
-update time for x records (measure time when start update and finish when done)
- select time for x records
-db needs to be populated before tests with minimum 1Mb data
- test heap usage
- test on server side:
-disk usage
-ram usage
-processor usage (sar tool)
- For every test I want using multithreading configurable parameter x of threads, minimum 2
-I want using db pool example hikari
-using prepared statements for query execution

The test for testing Select (get data from db) needs to include a join between order and order_history.

I want configurable parameters from test using console (picoclient): servername, serverip, server port, username, user password